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

CC BY-SA 4.0
2020-06-02T09:44:32.417Z
2020-06-02T09:44:32.417Z
Matthias Redl-Mann
<p>Have never tried it (usually see people asking to go the other way from MySQL to PostgreSQL).</p>

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

CC BY-SA 4.0
2020-06-02T09:41:39.180Z
we tried it, but had problems to get it to work...
Matthias Redl-Mann
CC BY-SA 4.0
2020-05-30T04:49:57.780Z
2020-05-30T04:49:57.780Z
Brad Bell
<p>We need to migrate a Craft installation with a pgsql dump to MySQL.</p>

<p>Any hints on the procedure?</p>

<p>Thanks,
Matthias</p>

CC BY-SA 4.0
2020-05-27T16:57:50.410Z
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. https://straightupcraft.com/events/migrating-a-website-with-plugins-from-craft-2-to-craft-3 but i want to know about dump and transition part myself.
user9975
CC BY-SA 4.0
2020-05-30T23:55:20.270Z
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
CC BY-SA 4.0
2020-06-02T09:43:27.520Z
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
CC BY-SA 4.0
2020-09-15T13:29:49.260Z
@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
<migration><mysql><postgresql>
Migrate Craft CMS installation from PgSQL to MySQL - any hints?
# Migrate Craft CMS installation from PgSQL to MySQL - any hints?

(Asked by: username_0 on 2020-05-27)

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

Any hints on the procedure?

Thanks,
Matthias

**Tags:** migration, mysql, postgresql
> **Comments:**
> **username_1**: 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. https://straightupcraft.com/events/migrating-a-website-with-plugins-from-craft-2-to-craft-3 but i want to know about dump and transition part myself.  
> **username_2**: 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.  
> **username_0**: 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.  
> **username_3**: @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  

---

## 2 answers

### Answer by username_0 on 2020-06-02. Score: 1 | Accepted answer

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


---

### Answer by username_4 on 2020-05-30. Score: 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/>).

> **Comments:**
> **username_0**: we tried it, but had problems to get it to work...  

---

