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
SUPPORT
VISIT COUNTER !!
Post a Comment