Proper way to migrate from MySQL to PostgreSQL

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
bmar
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 28 Mar 2013, 09:49
Location: NN, Russia

Re: Proper way to migrate from MySQL to PostgreSQL

Postby bmar » 12 Sep 2013, 08:21


bmar
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 28 Mar 2013, 09:49
Location: NN, Russia

Re: Proper way to migrate from MySQL to PostgreSQL

Postby bmar » 12 Sep 2013, 09:16


bmar
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 28 Mar 2013, 09:49
Location: NN, Russia

Re: Proper way to migrate from MySQL to PostgreSQL

Postby bmar » 12 Sep 2013, 15:29


hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Proper way to migrate from MySQL to PostgreSQL

Postby hrk » 12 Sep 2013, 21:22

I am not at home these days and I am writing from a smartphone.

Migration tool has no knowledge of table columns, just tables. Provided fox hasn't added a new table, you're fine.

It has to be run on an empty (but created!) pgsql schema. When you got "user table does not exist", you run it on a not existing schema.

It has to run on a schema with the same version you're migrating, you can't expect the tool to deal with new columns, new tables and such. :)

vilain
Bear Rating Trainee
Bear Rating Trainee
Posts: 40
Joined: 29 Jun 2013, 08:57

Re: Proper way to migrate from MySQL to PostgreSQL

Postby vilain » 13 Sep 2013, 01:49


bmar
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 28 Mar 2013, 09:49
Location: NN, Russia

Re: Proper way to migrate from MySQL to PostgreSQL

Postby bmar » 13 Sep 2013, 09:57


hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Proper way to migrate from MySQL to PostgreSQL

Postby hrk » 13 Sep 2013, 17:22


johnnychicago
Bear Rating Trainee
Bear Rating Trainee
Posts: 36
Joined: 25 Jul 2011, 23:26

Re: Proper way to migrate from MySQL to PostgreSQL

Postby johnnychicago » 26 Mar 2014, 15:42

@hrk --

Just wanted to inquire if you think your tool is still fit - I am pondering migrating an instance with a number of users (total around 3500 feeds) over. Obviously I will run a dry run before. But if there's a good reason from your end not to even bother, I'd be glad to know. :)

Thanks

XianPalin
Bear Rating Trainee
Bear Rating Trainee
Posts: 21
Joined: 16 May 2013, 23:10

Re: Proper way to migrate from MySQL to PostgreSQL

Postby XianPalin » 02 Apr 2014, 05:57

I'm not sure if this has been mentioned or not (I didn't read through the four pages), but there is a windows based tool here that does migration as well, and with some tweaking that I did last night I was able to migrate from mysql to postgresql on a local server on my network with no issues.

viewtopic.php?f=16&t=2795

It is a little work getting mysql and postgresql to accept non-localhost connections, if you haven't done that already.

hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Proper way to migrate from MySQL to PostgreSQL

Postby hrk » 02 Apr 2014, 16:11

Thank you for not reading before posting.

@johnnychicago: sorry I didn't see your message. I guess the tool is still fit, it will break only when fox adds new tables to the schema. I'll go check out if he did in 1.11 and 1.12.

e: @johnnychicago: yep, still valid.

johnnychicago
Bear Rating Trainee
Bear Rating Trainee
Posts: 36
Joined: 25 Jul 2011, 23:26

Re: Proper way to migrate from MySQL to PostgreSQL

Postby johnnychicago » 02 Apr 2014, 22:45


hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Proper way to migrate from MySQL to PostgreSQL

Postby hrk » 03 Apr 2014, 02:09


johnnychicago
Bear Rating Trainee
Bear Rating Trainee
Posts: 36
Joined: 25 Jul 2011, 23:26

Re: Proper way to migrate from MySQL to PostgreSQL

Postby johnnychicago » 03 Apr 2014, 10:36


hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Proper way to migrate from MySQL to PostgreSQL

Postby hrk » 03 Apr 2014, 12:57

Please, try it with -Xmx1024m and send me a PM with the full log. I'm astonished that MySQL's JDBC driver tries to load the whole table in memory. Alas, MySQL has always been a shit in terms of JDBC compliance and functionality.

hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Proper way to migrate from MySQL to PostgreSQL

Postby hrk » 03 Apr 2014, 23:54



Return to “Support”

Who is online

Users browsing this forum: No registered users and 5 guests