Command to repair crashed table

[Wardsweb]

I would normally go into my admin console and repair the database, but I can not login due to the error. What command line do I use in phpadmin to perform the repair?

Database error in vBulletin 3.8.0:

Invalid SQL:
DELETE FROM strikes WHERE striketime < 1272283995;

MySQL Error   : Table './adminda_driveaccord/strikes' is marked as crashed
and should be repaired
Error Number  : 145
Request Date  : Monday, April 26th 2010 @ 06:13:15 AM
Error Date    : Monday, April 26th 2010 @ 06:13:15 AM
Script        : [URL]http://www.driveaccord.net/forums/login.php?do=login[/URL]
Referrer      : [URL]http://www.driveaccord.net/forums/forumdisplay.php?f=15[/URL]

[borbole]

Tick the table name and all the way to the bottom where it says: With selected", choose for the repair option.

Or run this query at the SQL box,

REPAIR TABLE 'tablename';

And replace tablename with the actual name of the table that needs repairing. Hope it helps.

[Wardsweb]

Perfect - knowledge is a great thing.

Thanks

[borbole]

You are welcome.

[Homeworld'sa]

You should try to avoid using the built in acp table repair system, as this tends to do all sorts of things. Using your host's repair commands on their cPanel or w/e control panel they have is better and less risk of problems.