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.
