Forums / General / Migrating from PostgreSQL to MySQL

Migrating from PostgreSQL to MySQL

Next topic

Author	Message
Jonas Helgemo	Wednesday 18 February 2009 6:28:31 am I have an eZ site that is currently using PostgreSQL, but I need to migrate it to MySQL in order to move the site to a different server where the only possibility is to use MySQL. Is it possible to export the data from eZ to some standard format without having to deal with the database dumps (e.g some import/export function in eZ)? I have considered using some kind of PostgreSQL -> MySQL converter, but I'm not sure it would work with the complex database structure used in eZ. Any ideas or experiences on how to migrate the database backend from PostgreSQL to MySQL?
juan uribe	Sunday 08 March 2009 9:57:40 pm hi, hopefully you will read this... and replay.. I´m thinking also on migrating from postgreSQL to MySQL. For a very strange reason. My postgresql seems very unstable. My server runs two ez installs side by side, one on postgres and one on mysql. Mysql is strangelly enough faster and more stable. So I wanted to ask 1) after migrating how was performance 2) how did you achive the migration... Thanks---

Author

Message

Wednesday 18 February 2009 6:28:31 am

I have an eZ site that is currently using PostgreSQL, but I need to migrate it to MySQL in order to move the site to a different server where the only possibility is to use MySQL. Is it possible to export the data from eZ to some standard format without having to deal with the database dumps (e.g some import/export function in eZ)? I have considered using some kind of PostgreSQL -> MySQL converter, but I'm not sure it would work with the complex database structure used in eZ. Any ideas or experiences on how to migrate the database backend from PostgreSQL to MySQL?

juan uribe

Sunday 08 March 2009 9:57:40 pm

hi, hopefully you will read this... and replay..

I´m thinking also on migrating from postgreSQL to MySQL. For a very strange reason. My postgresql seems very unstable. My server runs two ez installs side by side, one on postgres and one on mysql. Mysql is strangelly enough faster and more stable.

So I wanted to ask 1) after migrating how was performance 2) how did you achive the migration...

Thanks---