MySQL Forums
Forum List  »  InnoDB

Re: import or appending with ibdata1, no mysqldump
Posted by: Rick James
Date: March 28, 2009 06:59PM

Ouch.
I move the entire data directory (ALL tables) between Unix machines. Not sure if it will work between Windows and Unix.

It will NOT work to move the .ibd file (if you have file-per-table).

You may be stuck with mysqldump.

Oh, another thought --
ALTER TABLE foo ENGINE = MyISAM;
Then you probably can copy the 3 MyISAM files, and do the ALTER back.
Caveat: You will lose FOREIGN KEY CONSTRAINTS in the process, but you could reapply them.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: import or appending with ibdata1, no mysqldump
3693
March 28, 2009 06:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.