mysql 数据备份脚本

2019独角兽企业重金招聘Python工程师标准>>>

/usr/local/mysql/bin/mysqlpump -uroot -p4rfv%TGB --add-drop-table --complete-insert -B db > /root/data/backup/data_`date +%Y%m%d`.sql 
find /root/data/backup/ -mtime +7 -name '*[0-9].sql' -exec rm -rf {} \;

 

转载于:https://my.oschina.net/tank1988/blog/1079066