mysql2 won't install on windows, use mysql gem instead. So, change this line gem 'mysql2', '~> 0.2.6' to gem 'mysql'
and in your config/database.yml file, change the adapter from *mysql2* to * mysql* for all 3 databases. Chirag http://sumeruonrails.com On Thu, Jul 28, 2011 at 4:14 PM, Amit Bobade <amit.sr...@gmail.com> wrote: > Hi, > > Gem file is as follows: > > source 'http://rubygems.org' > > gem 'rails', '3.0.9' > > # Bundle edge Rails instead: > # gem 'rails', :git => 'git://github.com/rails/rails.git' > > gem 'mysql2', '~> 0.2.6' > > # Use unicorn as the web server > # gem 'unicorn' > > # Deploy with Capistrano > # gem 'capistrano' > > # To use debugger (ruby-debug for Ruby 1.8.7+, ruby-debug19 for Ruby > 1.9.2+) > # gem 'ruby-debug' > # gem 'ruby-debug19', :require => 'ruby-debug' > > # Bundle the extra gems: > # gem 'bj' > # gem 'nokogiri' > # gem 'sqlite3-ruby', :require => 'sqlite3' > # gem 'aws-s3', :require => 'aws/s3' > > # Bundle gems for the local environment. Make sure to > # put test-only gems in this group so their generators > # and rake tasks are available in development mode: > # group :development, :test do > # gem 'webrat' > # end > > > > > On Thu, Jul 28, 2011 at 4:09 PM, Chirag Singhal > <chirag.sing...@gmail.com>wrote: > >> looks like you have wrong entry in your Gemfile. >> >> Can you attach or paste contents of your Gemfile? >> >> >> Chirag >> http://sumeruonrails.com >> >> >> >> On Thu, Jul 28, 2011 at 2:53 PM, Amit Bobade <amit.sr...@gmail.com>wrote: >> >>> Hi Chirag, >>> >>> I am still getting error while starting the rails. >>> <-[31mCould not find gem 'mysql112 (~> 0.2.6)' in any of the gem sources >>> listed in your Gemfile. <-[0m >>> >>> Please help on this, I found the gem file and added *gem 'mysql' *in to >>> it but it still shows error. please help on this. >>> >>> Thanks, >>> Amit >>> >>> >>> On Wed, Jun 29, 2011 at 12:08 PM, Chirag Singhal < >>> chirag.sing...@gmail.com> wrote: >>> >>>> It will be in your applications root folder. Along with the files like >>>> README, Rakefile, etc >>>> >>>> -- >>>> Chirag >>>> http://sumeruonrails.com >>>> >>>> >>>> On Wed, Jun 29, 2011 at 12:03 PM, Amit Bobade <amit.sr...@gmail.com>wrote: >>>> >>>>> 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.sing...@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.sr...@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.sing...@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.sr...@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.sing...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.