Re: Migrating geometry data

[Ludwig Brinckmann]

A highly portable way of migrating geo data from PostGIS to MySQL (and the other way round) is to go via an intermediate shapefile. Both PostGIS and MySQL have conversion routines to support this, meaning you do not have to rely on third party tools.

To convert from PostGIS to shape file, use

pgsql2shp -g geometry_column -f shapefile DB table

Then turn it into MySQL SQL:

shp2mysql -s SRID -c shapefile table DB > mysql.sql

and ingest the data:

mysql -D DB < mysql.sql

The last two steps can of course be done in one go, but the intermediate SQL file gives a better ability to check for sanity.

HTH

Ludwig