using mysql instead of sqlite in a rails app

Question

I'm not sure how to find what I'm looking for here, but I've cloned a rails app from someone else and they were using sqlite, how do I switch the project over to mysql? There are no migrations but it has a schema. Thanks.

Or rather is there a way to make a migration from a schema?

JP Silvashy
– JP Silvashy

2011-02-23 22:33:07 +00:00
Commented Feb 23, 2011 at 22:33 — JP Silvashy
– JP Silvashy, Commented Feb 23, 2011 at 22:33

Plattsy · Accepted Answer · 2011-02-24 00:19:40Z

3

Have you changed the database.yml?

eg:

development: 
  adapter: mysql
  encoding: utf8
  database: <db name here>
  pool: 5
  username: root
  password: <p/w>
  socket: /var/run/mysqld/mysqld.sock

answered Feb 24, 2011 at 0:19

Plattsy

5154 silver badges13 bronze badges

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

1 Comment

JP Silvashy Over a year ago

yah did all this. It's just annoying to have to run schema:load then db:migrate

cam · Accepted Answer · 2011-02-23 22:51:34Z

1

You don't need a migration. rake db:setup (or rake db:schema:load)

EDIT: this is assuming the schema is a schema.rb file. If it's an SQL file you'll have to convert that and then just run it using the mysql client.

answered Feb 23, 2011 at 22:51

cam

14.2k1 gold badge46 silver badges29 bronze badges

Comments

Bryan Drewery · Accepted Answer · 2011-05-09 16:36:37Z

0

hope this will helps you.

If you have some errors in the Database.yml file, you might have to install the mysql gem:

gem install mysql

Have rake create your database

rake db:create     
rake db:schema:load

Use YamlDb to reload your data into MySql

rake db:load

You really should use db:schema:load instead of db:migrate for creating new databases

edited May 9, 2011 at 16:36

Bryan Drewery

2,6531 gold badge20 silver badges13 bronze badges

answered May 9, 2011 at 11:41

nehit

1172 silver badges7 bronze badges

Collectives™ on Stack Overflow

using mysql instead of sqlite in a rails app

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related