how to change sqlite3 to mysql..??

rubyonrails-talk
#1

Hi,
im new to ruby on Rails..i install all ror files..if i try to work in
database there is sqlite3 is default.??.. if i change to mysql im
getting error...in localhost development side...??
how to change sqlite3 to mysql..?? help pls..??

#2

1) install MySQL
2) install mysql gem
3) edit config/database.yml appropriately
4) if you've already started development, run
       rake db:schema:load
    to install your tables

HTH,

#3

Please, be more specific. What error message are u getting?

Anyway, i suspect that it's because u don't have the mysql gem
installed.

Try installing it: gem install mysql

#4

If you're just getting started, create your project with:

rails myproject -d mysql

#5

Thank for reply...

#6

Thank for reply...

#7

Can u tell me how to install full RoR complete package with default of
database adapter with mysql .?im getting sqlite3 is default???

#8

Can u tell me how to install full RoR complete package with default of
database adapter with mysql .?im getting sqlite3 is default???

#9

Yes, SQLite3 is the current default; if you want to use something else
you need to follow the process I outlined.

HTH,

#10

Download edge Instantrails .
and make rails application from command promt

rails -d mysql applicationname
you can able to work with mysql.

#11

Hi, Schroeder

Can u tell me,? which editor is best for Ruby on Rails..apps??

#12

The one you're most proficient with :slight_smile:

At various times I use jEdit, NetBeans and vi for Rails development,
all reasonably cross-platform so I don't have to switch mental gears
too much going between Linux and Mac. YMMV,