ChrisLundquist / pg2mysql

Some patches for http://www.lightbox.ca/pg2mysql.php
136 stars 55 forks source link

Converting part by part does not work #2

Open Bouncner opened 10 years ago

Bouncner commented 10 years ago

Due to the large size of our data set we are currently splitting the dump file by "COPY FROM ..." to store every table data in a separate file which is later converted with pg2mysql.

I don't know too much about pg dumps, but in many cases there is a single select statement after a table, but it is not always the case. In case there is no final select statement, the converter does not write to disk as the condition around line 100 in pg2mysql.inc.php is not evaluating to true.

I know our case is a bit "strange", but why is " ); " being checked instead of " . " ?