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, 2020 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. May 30, 2020 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. Jun 2, 2020 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, 2020 at 13:29

2 Answers 2

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... Jun 2, 2020 at 9:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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