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