Repair MySQL Databases via SSH

Repair MySQL Database

Via command line in root mode, run:

mysqlcheck -r [database_name]

mysqlcheck –all-databases -r #repair
mysqlcheck –all-databases -a #analyze
mysqlcheck –all-databases -o #optimize

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

December 4, 2014   1119    Linux, SSH  
Total 1 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?


Leave a Comment