[postgis-users] geometry from postgis to mysql

[tashjp]

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.