Migrating from MySQL to PostgreSQL

@sr57 This did not help me in any way. It doesn't answer my question of how to transfer everything without losing anything from my current MySQL database.

@LarAlex How is that not helpful? There is a link for a tool that can do the work for you? If you scroll down half way on the page, there is even a step by step guide?

@Sinnbeck How is that helpful? Paying either 150 or 600 bux to convert MySQL database to PostgreSQL?

@LarAlex Personally I wouldnt find that a crazy price, if it meant that my huge production setup, didnt break

But it seems that pgloader is a free alternative (it is mentioned in the page)

https://github.com/dimitri/pgloader

https://pgloader.readthedocs.io/en/latest/ref/mysql.html

@Sinnbeck I can not find adequate documentation of pgloader how to use it. Maybe you can help me up how to set it up?

@LarAlex I havent used it but the instructions seems simple enough

1. Install the tool: https://github.com/dimitri/pgloader
2. Write a "load" file that defines what and how to migrate your data: https://pgloader.readthedocs.io/en/latest/ref/mysql.html
3. Run pgloader on the file you wrote in 2. : https://pgloader.readthedocs.io/en/latest/tutorial/tutorial.html

pgloader my_awesome_loader.load

@Sinnbeck Does this "load" file have some kind of structure? I'm so confused reading this documentation. I understand what I need to build in this file, but what is the structure behind it? First, what is actually mysql://root@localhost/sakila is that some endpoint URL or what?

@LarAlex That is a connection sting for mysql. It sets the protocol to mysql and the username to root. Then the hostname is localhost and database is sakila

Scroll down the page and you can see this: https://pgloader.readthedocs.io/en/latest/ref/mysql.html#mysql-database-source-specification-from

So you went with DBConvert or DBSync ? That is probably a bit easier to set up as well :)

@sinnbeck I used DBConvert. Didn't worked as expected, BUT WORKED!!