MySQL InnoDB issues

Dan Sampson 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!

Thanks,

Dan Sampson

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  
> same
> level as the database sub-directories, there are three InnoDB data
> files:
>
> ibdata1
> ib_logfile0
> ib_logfile1
>
> You'll need these in addition to the .frm files.
>
> HTH,
> Jeff
>
> /*
> 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 mailing list