migrating rails app from postgresql to mysql

Question

I'm attempting to migrate my rails application from postgresql to mySQL so as to view the data in one place within xampp in PHPmyadmin. The reason is the fact that I need to access the data that is located within the MySQL database from my rails app which is in postgresql.

As of now most questions I found aim to create a new application within mySQL with rails but I need to migrate all of the data my current rails application compatible and use MySQL.

Is there a proper process and simple procedure that allows for this migration from postgresql to mySQL?

Note: MySQL is within xampp

Community · Accepted Answer · 2017-05-23 11:57:42Z

0

this post

got the answer to your question.

It's very easy, just paste your postgres dump in this website and you'll get the same dump converted in mysql, ready for you to be imported.

Then you will just need to properly configure your database.yml and you're set.

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Aug 21, 2014 at 4:01

John Funk

989 bronze badges

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

Collectives™ on Stack Overflow

migrating rails app from postgresql to mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related