How to check and repair MySQL database tables?

In case you stumble across an error like: “Table ‘table_name’ is marked as crashed and should be repaired”, you’ll need to do the following:

cPanel

 In cPanel, you can repair a database table by:

cPanel -> Databases -> MySQL Databases

 

You may need to go to Page 2, so under Current Databases [2] or >> to go to the next page.

Under Modify Databases click [Check DB] or [Repair DB].

 

 Plesk

 

 Open the database in phpMyAdmin. To do that, go to your Plesk control panel, click “Websites and Domains,” click “Databases,” and then click the database in question. From there, click “Webadmin” under “Tools.” You will most likely be presented with phpMyAdmin.

 Next, click “Databases” in the upper right, click the database name, then scroll all the way down and click “Check All” to check all the tables. From the drop down menu, select “Check Tables” and your tables will immediately be checked. After that, you can decide which tables to select and choose “repair” from the drop down menu.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database...

How do I check the size of my database?

Using the below mentioned steps, we will show you how to check the size of your database so you...

I need a different version of PHP/MySQL

If for some reason you cannot install programs on your server like Joomla, Drupal, WordPress,...

How do I optimze mysql in Cpanel?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How do I optimze mysql in plesk ?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...