[postgis-users] migrating mysql database with skt geometries into a postgis db?

Mr. Puneet Kishor punk.kish at gmail.com
Fri Apr 20 06:52:13 PDT 2012

On Apr 20, 2012, at 12:38 AM, Robert Buckley wrote:

> Hi,
> I have this task....anyone got any tips on how to acheive thisß

I have been doing this, but it is not easy. Well, it may be easy for you, but it wasn't easy for me. The db I am working with is very complicated, so after banging my head against various approaches to dumping the data, cleaning it up, and trying to load it again in Pg, I gave up and simply selected each row in the MySQL db and inserted it into the Pg db. Took about a week writing the script correctly, and about 60 seconds to run it.

Puneet Kishor

More information about the postgis-users mailing list