Announcement

Collapse
No announcement yet.

Command to repair crashed table

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

  • 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

  • #2
    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.

    Comment


    • #3
      Perfect - knowledge is a great thing.

      Thanks

      Comment


      • #4
        You are welcome.

        Comment


        • #5
          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.
          That's it. If you REALLY can't say ANYTHING nice to me at all on this forum, then I am going to go insanely mad at you. I've had enough of the UNTOLD ABUSE you are all giving me and you should really be CONSIDERATE of other people.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X