On Saturday 20 August 2005 23:58, Aaron J. Seigo wrote: > do a pg_dump and tell it to export as sql inserts and include the table > defs (`man pg_dump` for that)... from there you'll have to deal with > mysql's non-standard SQL and any pgsql-isms that may have been used in > creating the database (though there are rather few of those these days). > your biggest problem will come in porting stored procedures, but if there > are none it'll just be down to working around mysql's idea of sql
Thanks Aaron. I was afraid that would be the solution.... My initial trials failed, so I can tell that I'll have to tweak the output file by hand... <sighs>. I had thought that I might be able to get fancy and export the tables to CSV, and then import the CSV in MySQL. A little scripting would automate this... But there's still no guarantee it'll work properly - It looks like there might be differences in the structure of the MySQL database... (If you're wondering, I have two websites using a CMS and Postgresql, but the support for PG is limited, and the CMS works better with MySQL. So need to migrate the existing data to MySQL....) Shawn _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
