« Sample of BIND Configuration Files | Main | Chkrootkit 0.46 Problem »
October 27, 2005
MySQL Log File
I didn't know MySQL log file until I tried to clean up unused databases today, the default file path is /var/db/mysql/hostname.err.
In my log file, there are many error messages about one certain table, the error is like:
read_next: Got error 127 when reading table ./database_name/table_name
MySQL tried to repair the table many times according to the log message, but the problem still exists. Made a quick search, it might be a bug of MySQL 4.0, some pages said it could be fixed by repairing the table, which didn't work for me.
Repair table with MySQL command line:
mysql> repair table table_name;
Category : MySQL
Posted by FreeBSD Newbie at October 27, 2005 09:53 PM