MySQL Forums
Forum List  »  InnoDB

Re: copying raw mysql data from one server to another
Posted by: Andrew Simkovsky
Date: September 11, 2013 08:07PM

As Peter mentioned, the database is not just a set of files. It's essentially a running "engine". So to get a clone of the whole instance, you would need to stop MySQL, copy the entire directory tree to the other server, then bring it up.

This is mostly relevant to innodb tables. With MyISAM you can cheat because there is no tablespace information. So you can copy just the frm, MYD, and MYI files from one server to another. Worst case is you would have to run a repair on the myisam table on the new database server.

But Peter is correct, in that if you want to do this with the source mysql database up and running, mysqldump is usually the immediate option.

Andrew Simkovsky
More mysql forums (and other databases):
http://www.dbtekpro.com/forums
Brand new! Just post!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: copying raw mysql data from one server to another
1666
September 11, 2013 08:07PM


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.