Alex, since the floating point format in all the common architectures is the same nowadays, you can freely copy data files and .frm files across platforms.
To avoid problems in table name case, use always lower case table names and database names: http://dev.mysql.com/doc/mysql/en/Moving.html " On Windows, InnoDB internally always stores database and table names 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 on Unix is to add the following line to the [mysqld] section of your `my.cnf' before you start creating your databases and tables: [mysqld] set-variable = lower_case_table_names=1 On Windows, lower_case_table_names is set to 1 by default. Like MyISAM data files, 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 were listed in section 16.9 Backing Up and Recovering an InnoDB Database. " Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html .................. Hi list, In general, is there any guarantee that the .frm and innodb files (including logs) will be exactly the same cross-platform? More specifically, would the database data files created on Windows work when placed on an OSX installation of the same version? Assume whatever version of mysql you are familiar with, although if it matters I'm using 4.0.20. The same configuration for each platforms' installation. My intent is to be able to distribute a pre-populated database on multiple platforms. It is desirable to conserve disk space by sharing the data files amongst distributions if possible. I've tested it and it appears to work. This is preferable to using mysqldump and importing when the typical end-user would have difficulty accomplishing that. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
