Tuesday, August 25, 2009

Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Solution:

1001 tail -f /var/lib/mysql/server.dizinc.com.err
1002 hostname
1003 tail -f /var/lib/mysql/dime138.dizinc.com.err
1004 ll /var/lib/mysql/mysql/
1005 ll /var/lib/mysql/mysql/
1006 myisamchk -r /var/lib/mysql/mysql/host.MYI
1007 ll /var/lib/mysql/mysql/
1008 cp /backup/cpbackup/daily/dirs/_var_lib_mysql/mysql/host.* /var/lib/mysql/mysql/
1009 chown -R mysql.mysql /var/lib/mysql/mysql/
1010 myisamchk -r /var/lib/mysql/mysql/*.MYI
1011 ll /var/lib/mysql/mys
1012 ll /var/lib/mysql/mysql/
1013 ps aux | grep mysql
1014 mysql
1015 ps aux | grep mysql
1016 mysql

No comments:

Post a Comment