Move An InnoDB Database

• On Windows, InnoDB always stores database and table names internally in lowercase.
  • To move databases in a binary format from Unix to Windows or from Windows to Unix, all table and database names should be in lowercase.
  • A convenient way to accomplish this is to add the following line to the [mysqld] section of the my.cnf file.

    [mysqld]
    

    lower_case_table_names=1

• Like MyISAM data files, InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format.
  • Move an InnoDB database simply by copying all the relevant files listed in the binary backup procedure.
  • If the formats differ and the tables contain floating-point data, use mysqldump to dump the tables on one machine and then import the dump files on the other machine.

What is the InnoDB transaction model?

---

---

© 2007 John Michael Pierobon

Notes