Re: Copying innodb databases to another machine

[Peter Beckman]

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.