Related note 0
Related note 1
Related note 2
Related note 3
Checking and Repairing the Database
The control panel allows you to check and repair database tables. The current version supports the check and repair of MyISAM tables. These operations are performed by means of the mysqlcheck utility.
MySQL :: MySQL 8.0 Reference Manual :: 18.2 The MyISAM Storage Engine
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
Add a caption...
MySQL :: MySQL 8.0 Reference Manual :: 6.5.3 mysqlcheck — A Table Maintenance Program
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
Add a caption...
Table of contents
Checking the database
Repairing the database
Checking the database
To check the integrity of the database, enter
Databases
→ select the database →
mysqlcheck
→
Start mysql check
→
Ok
.
The result of the check is displayed in the
mysqlcheck check status
column.
Add a caption...
To view the detailed report, enter
Databases
→ select the database →
mysqlcheck
→
Report
.
Add a caption...
Repairing the database
Note
We recommend creating a database backup before repairing it.
To repair all corrupted tables, enter
Databases
→ select the database →
mysqlcheck
→
Start mysql repair
→
Ok
.
To repair an individual table, enter
Databases
→ select the database →
mysqlcheck
→
Report
→ select the table →
Start mysql repair
→
Ok
.
Repair of an individual table may fail. In this case, it is recommended to run the repair for all tables of the database.