Import MySQL dump to Postres database using Ruby

Question

Hi I got a MySQL database dump, it's a sql file. Is there a way to import it to Postgres database using ruby? I know that there is a command like ActiveRecord::Base.connection.execute(IO.read("path/to/file")) but it fails, because of different databases. The main problem is to convert somehow sql file, to be a Postres format. Is it even possible using only Ruby On Rails?

Are you tried to use --compatible=name command line argument? — Maxim
– Maxim, Commented Feb 28, 2015 at 20:12
The problem is that I didn't even create this dump. I just got a sql file which I need to import to postgres database. I don't have acces to MySQL database. — Dawid
– Dawid, Commented Feb 28, 2015 at 20:16

Community · Accepted Answer · 2017-05-23 11:43:33Z

0

Have you checked out pgloader? http://pgloader.io/ It's really easy to use and has helped me lots.

Or I'll refer to this question; How to import existing *.sql files in PostgreSQL 8.4?

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Feb 28, 2015 at 20:20

Kevin Ferm

1113 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maxim · Accepted Answer · 2015-02-28 20:20:34Z

0

Try to use mysql2postgres. I have used it more than 5 years ago but seems like it supported yet.

answered Feb 28, 2015 at 20:20

Maxim

10k6 gold badges67 silver badges112 bronze badges

Collectives™ on Stack Overflow

Import MySQL dump to Postres database using Ruby

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related