[postgis-users] geometry from postgis to mysql

[Kyle.Wilcox at noaa.gov]

Have you tried using pgsql2shp and then shp2mysql?

----- Original Message -----
From: tashjp <tashjp at hotmail.com>
Date: Sunday, November 11, 2007 4:38 pm
Subject: [postgis-users] geometry from postgis to mysql

> 
> I had a go posting this in the MySQL forum but with no luck...
> I have a PostGIS database with various columns of geometry data. I 
> need to
> import all this into a MySQL database instead (my uni won't run 
> PostGIS on
> their servers) and have decided to create the tables from scratch 
> and then
> just do a search and replace on the insert statements to convert from
> Postgre to MySQL.
> 
> I have tried both
> 
> INSERT INTO RoadNode VALUES ('osgb4000000029762763', 3, '2005-09-14',
> 'osgb1000001824287062',
> 'GeomFromWKB(0101000000000000008A2B204100000000B07EF940)');
> 
> and 
> 
> INSERT INTO RoadNode VALUES ('osgb4000000029762711', 3, '2005-09-14',
> 'osgb1000001824287705', 
'010100000000000000082C2041000000006070F940');
> 
> both of which return the error message:
> >[Error] Script lines: 1-1 --------------------------
> Data truncation: Cannot get geometry object from data you send to the
> GEOMETRY field 
> 
> Does anyone know what I am doing wrong?
> 
> Thanks, Natasha 
> -- 
> View this message in context: http://www.nabble.com/geometry-from-
> postgis-to-mysql-tf4787330.html#a13695426
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>