Forums / Install & configuration / Migration from MySQL to PostgreSQL

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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 Exponential 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. Exponential does support PostgreSQL. But the conversion of an Exponential Mysql Db to a PostgreSQL is not really an Exponential specific question. Re: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL Cheers, Heath 7x \| https://se7enx.com/ Brookins Consulting \| https://brookinsconsulting.com/ Certified \| http://web.archive.org/web/201012...th.ez.no/certification/verify/380350 Solutions \| https://projects.exponential.earth/users/community/brookins-consulting eZpedia community documentation project \| http://ezpedia.se7enx.com
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 Exponential 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.

Exponential does support PostgreSQL.

But the conversion of an Exponential Mysql Db

to a PostgreSQL is not really an Exponential specific question.

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

Cheers,

Heath

7x | https://se7enx.com/
Brookins Consulting | https://brookinsconsulting.com/
Certified | http://web.archive.org/web/201012...th.ez.no/certification/verify/380350
Solutions | https://projects.exponential.earth/users/community/brookins-consulting
eZpedia community documentation project | http://ezpedia.se7enx.com

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