3

We need to migrate a Craft installation with a pgsql dump to MySQL.

Any hints on the procedure?

Thanks, Matthias

4
  • recently i saw a video - it's in 2018 though-, talking about migrating plugins from v2 to v3 but they talk about PostgreSQL from 1:42:00. maybe it helps from compatibility point of view. straightupcraft.com/events/… but i want to know about dump and transition part myself. – user9975 May 27 '20 at 16:57
  • I've tried it using a variety of tools... I think it's probably easier to export to a neutral format (JSON, XML, whatever) and re-import. None of the conversion tools I've used worked particularly well. – andrew.welch May 30 '20 at 23:55
  • we made the same experiences, we tried 3 different tools. workbench, a commercial migration tool and a php based script. none of them brought us a clean mysql db without errors when accessing Craft and its website afterwards. – Matthias Redl-Mann Jun 2 '20 at 9:43
  • @MatthiasRedl-Mann I am really curious why did you want to migrate? Because I was looking the other way around, migrating from MySQL to Postgre – Maverick Sep 15 '20 at 13:29
1

For others finding this post: we never made it. We invested > 2 days and then decided to stay with postgresql for this project.

0

Have never tried it (usually see people asking to go the other way from MySQL to PostgreSQL).

But after a quick Google search, I think the most promising option would be the migration tool built into MySQL Workbench (https://mysqlworkbench.org/2012/11/how-to-migrate-postgresql-databases-to-mysql-using-the-mysql-workbench-migration-wizard/).

1
  • we tried it, but had problems to get it to work... – Matthias Redl-Mann Jun 2 '20 at 9:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.