InnoDB DatabaseInnoDB always stores database and table names internally in lowercase.
[mysqld] section of the my.cnf file.
[mysqld]lower_case_table_names=1
MyISAM data files, InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format.
InnoDB database simply by copying all the relevant files listed in the binary backup procedure.
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