how to change sqlite3 to mysql..??

32 views
Skip to first unread message

haneef5k

unread,
Feb 20, 2009, 11:06:37 AM2/20/09
to Ruby on Rails: Talk
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..??

Hassan Schroeder

unread,
Feb 20, 2009, 11:19:31 AM2/20/09
to rubyonra...@googlegroups.com
On Fri, Feb 20, 2009 at 8:06 AM, haneef5k <hane...@gmail.com> wrote:

> how to change sqlite3 to mysql..??

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,
--
Hassan Schroeder ------------------------ hassan.s...@gmail.com

Leonardo Borges

unread,
Feb 20, 2009, 11:22:12 AM2/20/09
to Ruby on Rails: Talk

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

Ar Chron

unread,
Feb 20, 2009, 11:22:45 AM2/20/09
to rubyonra...@googlegroups.com
If you're just getting started, create your project with:

rails myproject -d mysql

--
Posted via http://www.ruby-forum.com/.

haneef5k

unread,
Feb 20, 2009, 11:23:55 AM2/20/09
to Ruby on Rails: Talk
Thank for reply...

On Feb 20, 9:19 pm, Hassan Schroeder <hassan.schroe...@gmail.com>
wrote:
> On Fri, Feb 20, 2009 at 8:06 AM, haneef5k <hanee...@gmail.com> wrote:
> > how to change sqlite3 to mysql..??
>
> 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,
> --
> Hassan Schroeder ------------------------ hassan.schroe...@gmail.com

haneef5k

unread,
Feb 20, 2009, 11:24:02 AM2/20/09
to Ruby on Rails: Talk
Thank for reply...
> > how to change sqlite3 to mysql..?? help pls..??- Hide quoted text -
>
> - Show quoted text -

haneef5k

unread,
Feb 20, 2009, 11:27:30 AM2/20/09
to Ruby on Rails: Talk
Can u tell me how to install full RoR complete package with default of
database adapter with mysql .?im getting sqlite3 is default???



On Feb 20, 9:19 pm, Hassan Schroeder <hassan.schroe...@gmail.com>
wrote:
> On Fri, Feb 20, 2009 at 8:06 AM, haneef5k <hanee...@gmail.com> wrote:
> > how to change sqlite3 to mysql..??
>
> 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,
> --
> Hassan Schroeder ------------------------ hassan.schroe...@gmail.com

haneef5k

unread,
Feb 20, 2009, 11:27:36 AM2/20/09
to Ruby on Rails: Talk
Can u tell me how to install full RoR complete package with default of
database adapter with mysql .?im getting sqlite3 is default???

Hassan Schroeder

unread,
Feb 20, 2009, 1:15:19 PM2/20/09
to rubyonra...@googlegroups.com
On Fri, Feb 20, 2009 at 8:27 AM, haneef5k <hane...@gmail.com> wrote:
>
> Can u tell me how to install full RoR complete package with default of
> database adapter with mysql .?im getting sqlite3 is default???

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

HTH,
--
Hassan Schroeder ------------------------ hassan.s...@gmail.com

Dharmdip Rathod

unread,
Feb 21, 2009, 6:10:31 AM2/21/09
to rubyonra...@googlegroups.com
Download edge Instantrails .
and make rails application from command promt

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

haneef5k

unread,
Mar 1, 2009, 12:26:34 AM3/1/09
to Ruby on Rails: Talk
Hi, Schroeder

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


On Feb 20, 9:19 pm, Hassan Schroeder <hassan.schroe...@gmail.com>
wrote:
> On Fri, Feb 20, 2009 at 8:06 AM, haneef5k <hanee...@gmail.com> wrote:
> > how to change sqlite3 to mysql..??
>
> 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,
> --
> Hassan Schroeder ------------------------ hassan.schroe...@gmail.com

Hassan Schroeder

unread,
Mar 1, 2009, 9:48:44 AM3/1/09
to rubyonra...@googlegroups.com
On Sat, Feb 28, 2009 at 9:26 PM, haneef5k <hane...@gmail.com> wrote:

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

The one you're most proficient with :-)

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,

Reply all
Reply to author
Forward
0 new messages