PG2MySQL Converter

Command-Line usage (recommended)

1. 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

2. php pg2mysql_cli.php pgfile.sql mysqlfile.sql [engine]

   • pgfile.sql will not be modified
   • mysqlfile.sql will be overwritten if already exists
   • engine is optional, default if not specified is InnoDB

3. mysql dbname < mysqlfile.sql

Additional behaviors

Auto-increment key type

The key type created for autoincrement fields is configureable via the PG2MYSQL_AUTOINCREMENT_KEY_TYPE environment variable.

The default is PRIMARY KEY. A simple KEY can be used to circumvent the fact that MySQL does not support multiple primary keys.

This option is particularly useful for converting dumps that have primary keys on the auto_increment field already defined as ALTER TABLE statements.

Usage example:

export PG2MYSQL_AUTOINCREMENT_KEY_TYPE=KEY
php pg2mysql_cli.php <options ...>

Web usage

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);

Original Author

Credit goes to:
Author: James Grant Lightbox Technolgoies
http://www.lightbox.org