MySQL InnoDB issues
jeff at zingstudios.com
Wed Feb 6 10:35:22 MST 2008
> we cannot get their InnoDB tables back up and running. I took their
> old data files, and moved them into the correct spot in the new
> mysql folder. When I load the database via command, I see the table
> names (show tables;) but when I select or desc the table it comes
> back with "ERROR 1033 (HY000): Incorrect information in file:
> './<databasename>/ <tablename>.frm'."
Did you copy the ib* files as well? In the MySQL directory, at the same
level as the database sub-directories, there are three InnoDB data
You'll need these in addition to the .frm files.
More information about the PLUG