plainblack.com
Username Password
search
Bookmark and Share

mysql 2 postgres converter

This script converts the webgui .sql files from MySQL format to Postgres format. It is a slightly modified version of the script from Maxim Rudensky. Usage: ./my2pg.pl create.sql > postgres-create.sql

System RequirementsPlease be advised: this contribution was tested with something older than WebGUI 7.5. When this contribution was uploaded there was no field for the author to fill out regarding it's requirements.
Comments
4bw: "Hi,

I'm having problems inserting the data into the PostgreSQL database.

It does look like the qsl is not generating the tables it suppose to do.

PostgreSQL 7.4.2
WebGUI 6.0.1

Any idea?

Is there a known bug in the my2pg.pl script?

Thanks,

  Bastiaan Wakkie"
3bw: "Well here is the sollution:

Edit the created postgres-create.sql in the following way :

After the creation of the table forum line 1000 something:
CREATE TABLE forum ...
The following insert data for "forum" are wrong.
INSERT INTO forum VALUES (....,'3153-60-00 00:00:00',...);
 FIX/
    Change all '3153-60-00 00:00:00' into '31536000'
/FIX

"
Downloadmy2pg_pl.txt my2pg_pl.txt
LinksNo Support Offered
Statistics Downloads: 1437
Views: 10468
Rating: 4
Updated: 8/12/2005
Keywords miscellaneous
NavigationBack to the Bazaar
© 2018 Plain Black Corporation | All Rights Reserved