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 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

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...