MySQL Log File
October 27, 2005 Posted by KP
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;
Related Posts:
- Monitor MySQL Log File
- Optimizing MySQL
- MySQL Backup and my.cnf
- MySQL Start Script
- MySQL Optimization
- Using Perl and MySQL
- Upgrade to PHP 5 and MySQL 5
- Disable Remote Access for MySQL
Filed Under: MySQL