-
PGPASSWORD=yourpass pg_dump -h localhost --quote-all-identifiers \
--no-acl --no-owner --format p --data-only dbname -f pgfile.sql
Additional documentation for
pg_dump
here -
php pg2mysql_cli.php pgfile.sql mysqlfile.sql [engine]
pgfile.sql
will not be modifiedmysqlfile.sql
will be overwritten if already exists- engine is optional, default if not specified is InnoDB
-
mysql dbname < mysqlfile.sql
To use, simply unzip into your website somewhere, and point your browser at pg2mysql.php
If you want to use your own interface, simply include the pg2mysql.inc.php into your own code and call the pg2mysql
function. It accepts one input (the postgres code to be converted) and returns the mysql code.
eg:
$mysql=pg2mysql($postgres);
Credit goes to:
Author: James Grant
Lightbox Technolgoies
http://www.lightbox.org