How to quickly copy a database from an old server to a new server
Resources:
Use the mysqldump command in conjunction with ssh
Posts Tagged ‘mysql’
Date Range SQL clause in ruby
Here is how to do it:
Date range to SQL clause
(6.months.ago.to_date..1.year.ago.to_date).to_s(:db) => ?BETWEEN ?2005-07-27? AND ?2005-01-22??
MySQL command line cheat sheet
Here is a great cheat sheet for all those mysql command line commands in terminal