On Saturday 20 August 2005 11:08, Shawn wrote: > Does anyone know any simple ways to move a database from PostgreSQL to > MySQL? > > I'm just starting to look into this, and so far searching for a phrase like > "Move PostgreSQL database to MySQL" on Google isn't being too helpful. I > know enough about SQL to do this manually, but REALLY want to avoid this - > I don't want to manually move 80+ tables and data... > > Any tips? Thanks.
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 -- Aaron J. Seigo GPG Fingerprint: 8B8B 2209 0C6F 7C47 B1EA EE75 D6B7 2EB1 A7F1 DB43 Full time KDE developer sponsored by Trolltech (http://www.trolltech.com)
pgpmukQQvGIQp.pgp
Description: PGP signature
_______________________________________________ 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
