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 <[email protected]>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 <[email protected]>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 < >> [email protected]> 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 <[email protected]>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 < >>>> [email protected]> 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 [email protected] >>>>> . >>>>> To unsubscribe from this group, send email to >>>>> [email protected]. >>>>> 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 [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]. >>>> 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 [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
