Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-02T09:44:32.417Z
Answers.LastActivityDate: 2020-06-02T09:44:32.417Z
Answers.UserDisplayName: Matthias Redl-Mann
Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-02T09:41:39.180Z
Answers.Text: we tried it, but had problems to get it to work...
Answers.UserDisplayName: Matthias Redl-Mann
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-30T04:49:57.780Z
Answers.LastActivityDate: 2020-05-30T04:49:57.780Z
Answers.UserDisplayName: Brad Bell
Body: <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>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-27T16:57:50.410Z
Comments.Text: 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.
Comments.UserDisplayName: user9975
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-30T23:55:20.270Z
Comments.Text: 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.
Comments.UserDisplayName: andrew.welch
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-06-02T09:43:27.520Z
Comments.Text: 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.
Comments.UserDisplayName: Matthias Redl-Mann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-15T13:29:49.260Z
Comments.Text: @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
Comments.UserDisplayName: Maverick
Tags: <migration><mysql><postgresql>
Title: Migrate Craft CMS installation from PgSQL to MySQL - any hints?
ThreadText: # 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,
  username_0
  
  **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**: @username_0 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...  
  
  ---
  
  