How to perform Database Migration from Postgres to MySQL ?

[malli_tech1994]

How to perform Database Migration from Postgres to MySQL ? 

Currently we are using Postgres Version 9.3.25 ,we need to upgrade to My SQL Version 8.x

[Brant Schroeder · Accepted solution]

@malli_tech1994 This will help you get it completed https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html 

[malli_tech1994]

Hi Brant Schroeder,

    I tried this process after testing connection with database its throwing 500 error.

database Test Connection is successful.

[Craig Castle-Mead]

Hi @malli_tech1994 

I would highly recommend considering why you are moving from psql to MySQL. While both databases are “supported” - the products appear to be developed against postgresql, and postgres seems to have less issues than MySql (or MSSQL) as a result.

We ran MySQL for many years, and spent a lot of effort moving to postgres and it’s been a much happier time since.

We used the XML export/import process to migrate, and had to do a lot of data cleanup as part of it. I’d ensure that you’re on a recent LTS or non-LTS version so you’ve got available bug fixes. 

For your current import issue - what do the application logs say when the 500 error is returned?

CCM