Make a quick dump of a mysql database:

mysql_dump db_name > backup-file.sql

You can then read that dump file back into the server like this

mysql db_name < backup-file.sql

or like this:

mysql -e "source /path/to/backup/backup-file.sql" db_name

First, isntall MySQL package installer from

http://dev.mysql.com/downloads/mysql/5.1.html#downloads

DON'T DOWNLOAD THE 64-BIT VERSION!!!
You must download the 32-bit version even if you have a 64-bit machine.

Then I was able to run this. Note: it is important to give the gem installer the -with-mysql-config flag, and point it to the file mysql_config inside the bin/ directory

sudo gem install mysql – -with-mysql-config=/usr/local/mysql/bin/mysql_config

© 2012 Tech Notes Suffusion theme by Sayontan Sinha