Repair db / table mysql on centos

Posted by blackonsole on April 3rd, 2011 12:57 AM | Tutorials

|| what is mysql
please take a look this..

|| how to repair db mysql on linux centos

# /etc/init.d/mysqld stop
# myisamchk -r -q /var/lib/mysql/DB_NAME/*.MYI
# /etc/init.d/mysqld start

# /etc/init.d/mysqld stop

# myisamchk -r -q /var/lib/mysql/DB_NAME/*.MYI

# /etc/init.d/mysqld start

|| how to repair table mysql

# /etc/init.d/mysqld stop
# myisamchk -r -q /var/lib/mysql/DB_NAME/TABLE_NAME.MYI
# /etc/init.d/mysqld start

# /etc/init.d/mysqld stop

# myisamchk -r -q /var/lib/mysql/DB_NAME/TABLE_NAME.MYI

# /etc/init.d/mysqld start