MyISAM tables ARE portable, e.g. from MAC to PC. InnoDB tables are not.
Barry At 10:19 PM 2/12/2006, Jeff Garrett wrote:
You miss one important point: MySQL databases are not (as far as i know) portable. Correct me if I'm wrong, but taking a database to a different machine (possibly with different type sizes and byte order) may not work. This would be a boon for packagers who could run the import on the TIGER or other datasets, and publish the resulting databases. SQLite doesn't have this problem, and there is a note in TODO suggesting moving to SQLite. (It doesn't have spatial indexing, but this is probably not be such a slowdown.)
_______________________________________________ roadster mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/roadster
