Database Optimisation Issue

[veenuisthebest]

Got the database up onto the new server. Could see the forum running as well.

Then when I ran the command "myisamchk -r *.MYI", all tables got corrupted.

Now, when I run "mysqlcheck -r -u USERNAME -p DATABASENAME", it shows the following for ALL tables.

Error : Incorrect information in file: './database/table.frm'
error : Corrupt

How did .frm got corrupt for all tables??

--------------- Added [DATE]1236638955[/DATE] at [TIME]1236638955[/TIME] ---------------

ALRIGHT..

So, I tried everything again. Reuploaded the backup, ran a mysqlcheck, then a myisamchk, and all went FINE.

mysqlcheck -r -u USERNAME -p DATABASENAME

myisamchk -r /path/to/database/dir/*.MYI

mysqlcheck -r -o USERNAME -p DATABASENAME


I can now see all tables being optimised quickly! and all show "Table is already upto date" after running optimization a couple of times. I also found 5 tables named something like aggregrate_temp_12515 etc. I deleted all 5.

Looking great uptill now.

Thanks

--------------- Added [DATE]1236661081[/DATE] at [TIME]1236661081[/TIME] ---------------

I finally took the backup of the FINE TUNED database and got it up. Everything working as expected. See I told you all it was a database issue