MySQL Forums
Forum List  »  InnoDB

Re: Copying innodb databases to another machine
Posted by: Peter Beckman
Date: July 06, 2005 07:04PM

I would do this.

- Shut down anything that talks to the DB.
- "select into outfile 'filename' from table"
- That will create a file. Compress and copy it to your new box
- either do a mysqldump or re-create manually your table structure on the new box
- "load data infile 'filename' into table `table`"

Now your data should be on the new box same way it was on the old box.

Options: ReplyQuote

Written By
Re: Copying innodb databases to another machine
July 06, 2005 07:04PM

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.