Migration from mysql to postgresql

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I want to migrate from mysql to postgresql.

I have a lot of databases and tables in mysql.
I can export them.

I need your guidance for importing the databases into postgresql.



Re: Migration from mysql to postgresql

shrini wrote:

Quoted text here. Click to load it

you might try requesting this from a postgresql forum....

try exporting your data in comma-seperated variable format and I am quite  
certain that postgresql has a method to import it.  (I am NOT a postgresql  

Re: Migration from mysql to postgresql

On 27 Mar 2006 03:51:45 -0800, shrini wrote...
Quoted text here. Click to load it

This is probably more specific to MySQL and PostgreSQL than PHP. Either of the
SQL databases have administrative tools to create a backup of your existing
databases. Those backups are normally formatted into SQL scripts that are used
to regenerate your tables and the content within them.

Don't think you could restore a PostgreSQL database from a MySQL backup, but the
back file will probably be pretty close to what you would need to recreate it
somewhere else.


Newsguy Bandwidth Blowout March-30-2006
Unlimited downloads all day long


Site Timeline