Changes between Version 8 and Version 9 of HowToMoveFromMySQLToPostgres

Timestamp:

07/13/09 00:15:24 (16 years ago)

Author:

heikki

Comment:

--

HowToMoveFromMySQLToPostgres

@@ -98 +98 @@
 === Exporting existing data from MySQL and importing it into Postgres ===
 
-TODO describe the process
+There are many ways to achieve this, and all of them require manual fiddling with data dumps and things like that.
+
+Many thanks to Thijs Brentjens who gave this excellent tip, I've found a relatively straightforward way of doing it using the tool [http://www.gdal.org/ogr2ogr.html ogr2ogr] which is part of the [http://www.gdal.org/index.html GDAL] tool suite. The ogr2ogr build I found on their web site does not include drivers for MySQL and Postgress though. Downloading the tool suite [http://fwtools.maptools.org/ FWTools], which includes GDAL, solved this.
 
 === Links to related information ===