`

JoyentJoyent

Knowledge Base

9.7. Repairing a MySQL table

To repair a corrupted MySQL (MyISAM) table either follow this video, or the steps bellow.

  1. Login to phpMyAdmin (https://mysql.server.textdrive.com/).

    Note: You'll need to substitute server with the name of the actual server for your account.

  2. Select a database from the drop down menu on the left. A list of tables in that db will appear directly below the drop down menu.
  3. In the main content area, select the check box next to the table you want to repair
  4. In the With Selected drop down below, select Repair Table. You should now see a SQL-query message telling you that the status of the table is OK
  5. At the top of the main content area, click the STRUCTURE tab
  6. Select the same table again but this time select Optimize Table from the With Selected drop down. You should now see a SQL-query message telling you that the status of the table is OK.

Your MySQL table should now be repaired.