GNU Info

(mysql.info)Moving

---

Next: InnoDB transaction model Prev: Backing up Up: InnoDB

---

Enter node , (file) or (file)node

Moving an InnoDB database to another machine
--------------------------------------------

InnoDB data and log files are binary-compatible on all platforms if the
floating point number format on the machines is the same.  You can move
an InnoDB database simply by copying all the relevant files, which we
already listed in the previous section on backing up a database. If the
floating point formats on the machines are different but you have not
used `FLOAT' or `DOUBLE' data types in your tables then the procedure
is the same: just copy the relevant files. If the formats are different
and your tables contain floating point data, you have to use `mysqldump'
and `mysqlimport' to move those tables.

A performance tip is to switch off the auto commit when you import data
into your database, assuming your tablespace has enough space for the
big rollback segment the big import transaction will generate.  Do the
commit only after importing a whole table or a segment of a table.