mikwat code

When importing a large MySQL dump file, use pv to monitor the progress of data through a pipe:
pv -petr dumpfile.sql | mysql -uroot my_database

This will give you a progress indicator such as:
0:00:05 [3.63MB/s] [===>        ] 0% ETA 0:09:41

After getting the dreaded uninitialized constant MysqlCompat::MysqlRes error on OS X Snow Leopard, I finally found a solution.

Error:

$ rake db:migrate
...
rake aborted!
uninitialized constant MysqlCompat::MysqlRes

Solution from http://techliberty.blogspot.com/:

sudo gem uninstall mysql
sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config