mySQL error 1033

If you ever come across this error after having to do an emergency reformat of a server (ugh) it’s usually because the innodb settings changed in the my.cnf file.

The easy way to fix this is to delete your ib_logfile* files in /var/lib/mysql and restart mysql. It will recreate them and everything should work just fine and dandy again – at least well enough to dump tables and recreate.

This error can also be caused by a tmp directory with improper permissions.

Hopefully this will help someone.

About John

Canadian ex-pat living in San Diego. Hacker, entrepreneur, surfer, scuba diver
This entry was posted in Servers. Bookmark the permalink.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>