Announcement

Collapse
No announcement yet.

Command to repair crashed table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Homeworld'sa
    replied
    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.

    Leave a comment:


  • borbole
    replied
    You are welcome.

    Leave a comment:


  • Wardsweb
    replied
    Perfect - knowledge is a great thing.

    Thanks

    Leave a comment:


  • borbole
    replied
    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,

    Code:
    REPAIR TABLE 'tablename';
    And replace tablename with the actual name of the table that needs repairing. Hope it helps.

    Leave a comment:


  • Wardsweb
    started a topic Command to repair crashed table

    Command to repair crashed table

    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?

    Code:
    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        : http://www.driveaccord.net/forums/login.php?do=login
    Referrer      : http://www.driveaccord.net/forums/forumdisplay.php?f=15
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X