In article <1065126701.1431.8.camel@localhost.localdomain>,
Scott Cain <cain@cshl.org> writes:
> Well, I've not done it, but you could do a
> pg_dump -s dbname >schema.sql
> pg_dump -d -a dbname >data.sql
> to get just the schema in one file and the data in inserts in another
> file. Then you could use a perl script driven by SQL::Translator (check
> http://www.cpan.org) to translate the schema from Pg to MySQL. Create
> the schema in MySQL, then load via the inserts.
I'd replace the second call of pg_dump by a "COPY mytbl TO 'mytbl.txt'"
for each table in the DB and import it into MySQL with "LOAD DATA
[LOCAL] INFILE". This would be much faster than INSERTing.
