Error Codes > 1033

Categories

Error Codes, Server Error Codes

Definition

Error 1033 generally points to corruption of the .frm file for the table being queried. This can be caused by InnoDB reconfiguration, form file corruption, and permissions issued.

Sample

SELECT COUNT(*) FROM auth;
ERROR 1033 (HY000): Incorrect information in file: './auth/auth.frm

Resolution

  • Check that the permissions on /tmp/ allow for reading and writing by the mysql user.
  • Stop MySQL, delete the ib_logfile0 and ib_logfile1 files from your MySQL datadir and start MySQL.
  • Restore from a backup.

Further Reference

Explanation of Error 1033 in relation to InnoDB

Explanation of Error 1033 and /tmp/

This entry was initially created on Friday, August 17th, 2007 at 3:55 pm and was last modified on Friday, August 17th, 2007 at 3:55 pm.
This entry is filed under Error Codes, Server Error Codes. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.

Leave a Reply