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 Repair DB: 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.
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 Repair DB: 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.
- admin
- Site Admin
- Posts: 13
- Joined: Sat Jul 30, 2011 10:01 pm
my SQL is one the best way to connect your database with your application. As these steps are uch helpful in providing best it consultant for database connectivity.
ReplyDelete