Migration from MySQL to PostgreSQL

Previous topic

Install & configuration

Next topic

Author	Message
Ken Nguyen	Friday 05 November 2010 8:20:48 am Hello, I have an eZ publish Website which is using MySQL db. I would like to know if it's possible to migrate MySQL to PostgreSQL. Thanks in advance.
Heath	Friday 05 November 2010 6:06:03 pm Hello Kenneth, Welcome to the eZ Community. eZ Publish does support PostgreSQL. But the conversion of an eZ Publish Mysql Db to a PostgreSQL is not really an eZ Publish specific question. Re: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL Cheers, Heath Brookins Consulting \| http://brookinsconsulting.com/ Certified \| http://auth.ez.no/certification/verify/380350 Solutions \| http://projects.ez.no/users/community/brookins_consulting eZpedia community documentation project \| http://ezpedia.org
Gaetano Giunta	Saturday 06 November 2010 6:25:51 am There are also some php scripts in eZP that can be of use: ezsqldumpschema.php and ezsqlinsertschema.php. Using the two of them, you should be able to migrate an existing eZ database from mysql to postgresql and viceversa. Principal Consultant International Business Member of the Community Project Board

Author

Message

Ken Nguyen

Friday 05 November 2010 8:20:48 am

Hello,

I have an eZ publish Website which is using MySQL db.

I would like to know if it's possible to migrate MySQL to PostgreSQL.

Thanks in advance.

Heath

Friday 05 November 2010 6:06:03 pm

Hello Kenneth,

Welcome to the eZ Community.

eZ Publish does support PostgreSQL.

But the conversion of an eZ Publish Mysql Db

to a PostgreSQL is not really an eZ Publish specific question.

Re: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL

Cheers,

Heath

Brookins Consulting | http://brookinsconsulting.com/
Certified | http://auth.ez.no/certification/verify/380350
Solutions | http://projects.ez.no/users/community/brookins_consulting
eZpedia community documentation project | http://ezpedia.org

Gaetano Giunta

Saturday 06 November 2010 6:25:51 am

There are also some php scripts in eZP that can be of use: ezsqldumpschema.php and ezsqlinsertschema.php. Using the two of them, you should be able to migrate an existing eZ database from mysql to postgresql and viceversa.

Principal Consultant International Business
Member of the Community Project Board