Ruby on Rails

Hi Chirag,

Thanks for your great help. I have one more question. It may be a silly one. You suggested that 

in your Gemfile, add:

gem 'mysql'

I am not clear with the Gemfile. Please tell me where to find it. 

On Wed, Jun 29, 2011 at 11:52 AM, Chirag Singhal <chirag.singhal@gmail.com> wrote:

Two ways:

1. You can specify that while creating your project - rails new myapp -d mysql

2. Manually modify your database.yml file to use mysql and update your Gemfile to use mysql gem

sample config for database.yml, you will need similar entries for production and test databases

development:

  adapter: mysql

  encoding: utf8

  reconnect: false

  database: myapp_development

  pool: 5

  username: root

  password: password

  host: localhost

in your Gemfile, add:

gem 'mysql'

-- 
Chirag

http://sumeruonrails.com

On Wed, Jun 29, 2011 at 11:32 AM, Amit Bobade <amit.srpce@gmail.com> wrote:

Thank you very much Chirag. It worked. Could you please tell me how to replace SQLite with MySQL? 

   

On Wed, Jun 29, 2011 at 11:08 AM, Chirag Singhal <chirag.singhal@gmail.com> wrote:

Make sure that you have sqlite3 installed on your machine and sqlite3 gem is also installed.

If you don't have sqlite3 installed on windows, then you can grab sqlite3.dll from here http://www.sqlite.org/download.html and copy it to either your ruby bin directory or windows' system32 directory. Open up a new console and run the server again.

As an aside, I have found that RailsInstaller works pretty well for all this default setup on windows. You may want to try it out - http://railsinstaller.org/

-- 
Chirag

http://sumeruonrails.com

On Wed, Jun 29, 2011 at 10:57 AM, Amit Bobade <amit.srpce@gmail.com> wrote:

Thanks for your prompt replies. I am using Rails 3.0.9 version. I used 'ruby script/rails server' command. 

But I am getting following error pop-up while running this command. 

The procedure entry point sqlite3_column_database_name could not be located in the dynamic link library sqlite3.dll

Please suggest some solution. 

Thanks,

Amit

On Tue, Jun 28, 2011 at 6:08 PM, Chirag Singhal <chirag.singhal@gmail.com> wrote:

You didn't specify which Rails version you are using.

Looks like you are on Rails 3, in that case, on of the following two should work:

rails server (shorthand is rails s)

or

ruby script/rails server

You may also want to read up Rails guides, which is very good if you are a beginner and will address these basic issues - http://guides.rubyonrails.org/getting_started.html

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.

To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/uKCg5GXX4o8J.

To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
Thanks and Regards,

Amit

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
Thanks and Regards,

Amit

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
Thanks and Regards,

Amit

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.