Repairing database tables (without phpMyAdmin)
#1
Hi,

Whenever you get a MySQL error message saying that a specific table is marked as crashed and it needs repairing and you can't - or don't know how to - use PhpMyAdmin we came up with the following solution:

Download this copy of repair.php and upload it to your forums directory and call it via your browser.

Example: http://www.mydomain.com/forums/repair.php

You should get a message saying "Done" if the table is repaired correctly.


Note: by default this file repairs the mybb_threadsread table. If you want to repair another table, just open up repair.php

and find

// Change this to the table you want to repair
$table = TABLE_PREFIX."threadsread";

and modify "threadsread" into another table name.


Have fun,
destroyer
[Image: destroyerjf8.jpg]

Give us your feedback about MyBB in this thread and become listed on the MyBB website.
Reply


Messages In This Thread
Repairing database tables (without phpMyAdmin) - by destroyer - 2007-08-12, 12:02 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)