MySQL InnoDB issues
plug at eharborinc.com
Wed Feb 6 11:06:06 MST 2008
That did it! Thank you so much!
Again, Plug.org saves a companies bacon!
On Feb 6, 2008, at 10:35 AM, Jeff Schroeder wrote:
> Dan asked:
>> 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
> level as the database sub-directories, there are three InnoDB data
> You'll need these in addition to the .frm files.
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
More information about the PLUG