View Post                                                                                                                                                                                                  Bookmark and Share
Technical Blogs
The posts written in this blog are related to technical.
 
MySQL 1033 Error

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.

Who By RaghavendraRao Ramisetty   Refer to Friend
When On 09/Jul/2009   Time At 08/Sep/2010 05:01 PM


 
Comments for this post: 2
Add Comments