Repairing database tables (without phpMyAdmin)

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.


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,
[Image: destroyerjf8.jpg]

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

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)