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. */
