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.
Subject
Views
Written By
Posted
6278
March 27, 2009 05:18PM
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.