(mysql.info) moving

(mysql.info) innodb-transaction-model

 
 14.2.9 Moving an `InnoDB' Database to Another Machine
 -----------------------------------------------------
 
 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, you should have all table and database names
 in lowercase. A convenient way to accomplish this is to add the
 following line to the `[mysqld]' section of your `my.cnf' or `my.ini'
 file before creating any databases or tables:
 
      [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. You can move an `InnoDB' database simply by copying all
 the relevant files listed in  innodb-backup.  If the
 floating-point formats differ but you have not used `FLOAT' or `DOUBLE'
 data types in your tables, then the procedure is the same: simply copy
 the relevant files. If the formats differ and your tables contain
 floating-point data, you must use `mysqldump' to dump your tables on
 one machine and then import the dump files on the other machine.
 
 One way to increase performance is to switch off autocommit mode when
 importing data, assuming that the tablespace has enough space for the
 big rollback segment that the import transactions generate. Do the
 commit only after importing a whole table or a segment of a table.

Info Catalog

(mysql.info) innodb-backup

(mysql.info) innodb

(mysql.info) innodb-transaction-model

automatically generated byinfo2html