Forums / Install & configuration / Migration from MySQL to PostgreSQL
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,
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