See also [[Database:Database]], [[Database:MySQL]], [[Database:Postgresql]]

====== Migrate MySQL to Postgres ======

Just a little bit of sample code.

<code bash>
~/devel2/mysql2pgsql$ ./my2pg.py --mysql-user=timb --mysql-password=timb_password --pg-user=drupal --pg-password=drupal_password pc015 tbruce57 pc015 tbruce

$ psql -h pc015 -U timb -W tbruce

$ ./my2pg.py --mysql-user=timb --mysql-password=timb_passworrd --pg-user=pg_user --pg-password=pg_password pc015 horoscope pc015 horoscope
</code>

Reference: http://www.togaware.com/linux/survivor/Remote_Host.shtml