MySQL .frm recovery
I had problems with my hard driver that caused my MySQL tables to be inaccessible. I was getting “#1033 – Incorrect information in file” error. I checked the files if there where obvious anomalies on the file caused by cross-linked file pointers but the files looked ok.
I had just reinstalled my MySQL due to the corruption and didn’t realize that this database was using InnoDB. I thought it was enough to backup and restore the database directory as that would be enough for MyISAM databases. Later I tried copying the InnoDB files from the data directory of the old installation. It didn’t work at first until I re-started my computer. The database was recovered after that (structure and data).
No comments yet.
Leave a comment
-
Recent
- My Move to the OSX (the dark-side)
- Skype & Apache conflict
- Simple yet effective way to replicate/mirror a database (any database at that)
- MySQL .frm recovery
- cakePHP calls crashing Apache
- Reformatting the default CakePHP layout (default.ctp)
- Syntax highlighting CakePHP using Eclipse
- Intersecting Entities on CakePHP Models
- Integrating Flickr into my PHP web-app
- Installing CakePHP
- Accessing a POP3 mailbox using PHP
-
Links
-
Archives
- October 2009 (2)
- April 2009 (2)
- February 2008 (1)
- January 2008 (6)
-
Categories
-
RSS
Entries RSS
Comments RSS