Cartika

Welcome, Guest Login

Support Center

How to repair a crashed MySQL table/database

Last Updated: Jun 09, 2014 06:15PM EDT
Symptoms: If your site/application is displaying something similar to:



Table './user_dbname/dbprefix_table' is marked as crashed and should be repaired



Resolution:



1. Access phpMyAdmin (link can be found in your control panel under Database -> MySQL -> MySQL Databases -> DB Name)

2. Select the database with the affected table from the pulldown list on the left side of the screen.

3. Click on the "SQL" tab on the right side of the screen

4. Type in the following and click "Go":



repair table tablename-to-be-repaired;



This will run a repair against just that table.



For a GUI method (and to repair multiple tables), please see http://paulstamatiou.com/how-to-quickie-repair-mysql-tables-in-phpmyadmin

Contact Us

sales@cartika.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete