im getting my laptop ready for training class and having issues with mysql i am able to get a project running using sqlite, but not mysql
instructions i followed for installation are here: http://wiki.rubyonrails.org/getting-started/installation/windows
i created a project and quick scaffold successfully
rails test_mysql -d mysql cd test_mysql ruby script/generate scaffold location name:string
i then tried to create db but received error rake db:create (in C:/Documents and Settings/dan/sites/test_mysql) c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_a dapters/mysql_adapter.rb:197: [BUG] Segmentation fault ruby 1.8.6 (2007-09-24) [i386-mswin32]
modified database.yml to include root users password and ran rake again rake db:create test_mysql_development already exists
so i tried to migrate... rake db:migrate (in C:/Documents and Settings/dan/sites/test_mysql) rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB
why is mysql being so difficult?
ruby 1.8.6 mysql 5.1.41
*** LOCAL GEMS ***
actionmailer (2.3.4) actionpack (2.3.4) activerecord (2.3.4) activeresource (2.3.4) activesupport (2.3.4) fxri (0.3.6) fxruby (1.6.12) hpricot (0.6) log4r (1.0.5) mysql (2.8.1) rack (1.0.1) rails (2.3.4) rake (0.8.7, 0.7.3) sources (0.0.1) sqlite3-ruby (1.2.3) win32-api (1.0.4) win32-clipboard (0.4.3) win32-dir (0.3.2) win32-eventlog (0.4.6) win32-file (0.5.4) win32-file-stat (1.2.7) win32-process (0.5.3) win32-sapi (0.1.4) win32-sound (0.4.1) windows-api (0.2.0) windows-pr (0.7.2)