mysqldump

mysql_tricks.sh

# create uncompressed dump
mysqldump -u root --databases soundcloud_test > dump.sql
mysql -u root < dump.sql 


# create compressed dump
mysqldump -u root --databases soundcloud_test | gzip  > dump.sql.gz
gunzip < dump.sql.gz | mysql -u root


# create csv files
## with column names
mysql -B -u root -D soundcloud_test -e "select * from app_tags" | tee table.csv

## without column names
mysql -B --skip-column-names -u root -D soundcloud_test -e "select * from app_tags" | tee table.csv


# setup cron job
crontab -e
*/1 * * * * /usr/local/bin/mysqldump -u root --databases soundcloud_test > /Users/jankischkel/tmp/dump.sql