Database Optimisation Issue

[BSMedia]

No problem!

You may have to do it two to three times.

Try not to use the vBulletin repair tool, not only can it repair tables, but it can also break your database, its usually always best to SSH if available

Good luck

[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