[Solved] Problem with migration-assist pgloader when migrating from MySQL to Posgres

Troubleshooting
1

Summary
migration-assist pgloader fails when migrating from MySQL to Postgres

Steps to reproduce
migration-assist pgloader --mysql=“<MYSQL_DSN>” --postgres=“<POSTGRES_DSN>” > migration.load

Expected behavior

  1. migration-assist mysql "<MYSQL_DSN>" succeeded
  2. migration-assist postgres "<POSTGRES_DSN>" --run-migrations --mattermost-version="v10.1.1" succeeded
  3. migration-assist pgloader --mysql="<MYSQL_DSN>" --postgres="<POSTGRES_DSN>" > migration.load failed with error

For 3) my command looks in detail like this:
./migration-assist pgloader --postgres="postgres://mattermost_db1:PASSWORD@127.0.0.1:5432/mattermost_db1" --mysql="mattermost_db1:PASSWORD@tcp(127.0.0.1:3306)/mattermost_db1" > migration.load

Observed behavior
For 3) the error message is like this:
An Error Occurred: could not generate config: could not parse mysql DSN: no match found

Can someone help and tell me if my DSNs are somewhere wrong?

2

Solved, there had been a special char (@) in the password

1 Like
3

Thank you autoflow for following up with the solution! Glad to hear all is working now.

4

could you give an example of your mysql dsn that actually worked? I’m experiencing the same issue & can’t figure out why.