crontab -e 每天定时备份mysql

contab -e
00 03 * * * mysqldump -u juandx --password=wenbin -d 'juandx$blog' -h host > /home/juandx/backups/myblog_$(date +\%Y\%m\%d_\%H\%M\%S).sql
00 03 * * * mysqldump -u juandx --password=wenbin -t 'juandx$blog' -h host > /home/juandx/backups/myblog-table_$(date +\%Y\%m\%d_\%H\%M\%S).sql

mysqldump -u juandx --password=wenbin -t 'juandx$blog' 'table' -h host > table_bck.sql

mysql -u username -p test_db < test_db.sql    

    mysql> sourcetest_db.sql