[Roadster] Converting TIGER data to a MySQL database

[Barry Gould]

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.)