Saari Development

I started doing my webapp on my brand new server (ubuntu linux 7.04) and when trying to run my first migration I got the following error message:

rake db:migrate(in /home/rizvi/projects/somewebapp)rake aborted!No such file or directory - /tmp/mysql.sock

Here is a useful mysql command to find out mysql defaults:

mysqladmin --print-defaultsmysqladmin would have been started with the following arguments:--port=3306 --socket=/var/run/mysqld/mysqld.sock

Here is what solved the problem:

sudo apt-get install libmysql-ruby

Note: The above is an alternative to :

sudo gem install mysql

Now I get:

rake db:migrate(in /home/rizvi/projects/somewebapp)rake aborted!Unknown database 'somewebapp_development'(See full trace by running task with --trace)

So I need to do the following:

mysqladmin -u root create somewebapp_development -pmysqladmin -u root create somewebapp_test -pmysqladmin -u root create somewebapp_production -p

Reference: RailsOnUbuntu