How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database. 

  • 1) Through cPanel: 

Log in to your cPanel and go to MySQL Databases. In the section Modify Databases, select a database from the drop-down box next to   and then click the Repair DB button.

 

If the database engine used by your database supports repair (for example, MyISAM supports it), you will see a list of the repaired tables within the database.

 

If your database engine does not support repair (e.g. InnoDB database engine), you will get the following error message:

 

note : The storage engine for the table doesn't support repair

 
  • 2) Through phpMyAdmin: 

Open your phpMyAdmin tool and select the database whose tables you wish to repair.

 

A list with all the database's tables will appear. Tick the tables you wish to repair, or simply click [Check All] to select all tables.

 

Click the box [With selected:] and choose Repair table. This will execute the REPAIR TABLE SQL query on the selected tables and they will be repaired.

  • 27 Users Found This Useful
這篇文章有幫助嗎?

相關文章

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to optimize a MySQL database using phpMyAdmin?

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

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...

I have problems accessing my MySQL database remotely

If you have problems accessing your database at your web hosting account remotely please make...