by
Rohit Patel

How To Repair MYSQL Databases In cPanel

How To Repair MySQL Databases

How To Repair MYSQL Databases

How to repair MYSQL databases :

Following commands will help to repair mysql databases.

1. The below command will repair all databases in the server:

====
# myisamchk -r /var/lib/mysql/*/*.MYI

# /etc/init.d/mysql restart

====

2. The following command will help us to understand whether to repair the databases or not.

====
# myisamchk -check /var/lib/mysql/*/ *.MYI
====

3. First we can try to safe-recover the databases:
====
# myisamchk -safe-recover /var/lib/mysql/*/*.MYI

OR

# myisamchk -recover /var/lib/mysql/*/*.MYI
=====

4. You can try forceful recover using the following command:
====
# myisamchk -safe-recover -extend-check -force /var/lib/mysql/*/*.MYI

# myisamchk -recover -extend-check -force /var/lib/mysql/*/*.MYI
====

FEED