My main prosper202 just crashed.

[iliketurtles]

Got this error

INSERT INTO 202_clicks_advance SET click_id='4490285', text_ad_id='0', keyword_id='11311', ip_id='3492939', platform_id='1', browser_id='9'

Table './abc_prosper202/202_clicks_advance' is marked as crashed and last (automatic?) repair failed

Any tips on how to fix this?

This domain has acquired a good 4.5 million clicks and it's getting slower and slower every day.

I just don't want to delete old click data (IP, referrer, time stamp, etc) because I've spent so much money in acquiring it and it shouldn't just be deleted for the sake of simplicity.

Thank God this happened during the night (when most of my offers are paused) and that I have multiple prosper202's installed so a few of my campaigns are still alive but I can't imaging what would happen if my prosper202 were to crash during the daytime when clicks are flooding in as fast as they can...

 

[roclafamilia]

this on an unmanaged VPS/Dedi?

 

[justo_tx]

I just don't want to delete old click data (IP, referrer, time stamp, etc) because I've spent so much money in acquiring it and it shouldn't just be deleted for the sake of simplicity.

step 0. ----> face palm <---- (optional)

step 1. archive your data to a new table....

select *
into Pre2010Activity
from WhateverTable
where TimeStampColumnName <= '2010-12-31 23:59:59'

step 2. disable any foreign key references to the table you just archived

step 3. delete the archived data

delete WhateverTable
where TimeStampColumnName <= '2010-12-31 23:59:59'

step 4. re-enable foreign key constraints with NOCHECK


Check for the ANSI compliant or the MySQL specific syntax of the steps I just laid out but that's them in pseudo.