Wednesday, December 21, 2011

Repairing a Corrupted Database in MYSQL

[root@123]#

mysqlcheck --auto-repair --databases database-name -uUser -pPass (for {INNODB} and MYSQL service should be running)

And

[root@123]#

myisamchk /var/lib/mysql/database-name/*.MYI ( for {MyISAM} and MYSQL service should be stopped)

 

0 comments:

Post a Comment