先在/var/local/中创建一个mysqlback.sh 备份的执行脚本
#!/bin/bash
mysqldump -u root -p'secret' --opt basename > /tmp/backup`date+%Y-%m-%d`
tar fvc /mysql/backup/bk`date +%Y-%m-%d`.sql /tmp/backup`date+%Y-%m-%d`
在crontab 中添加一行
mysqldump -u root -p'secret' --opt basename > /tmp/backup`date+%Y-%m-%d`
tar fvc /mysql/backup/bk`date +%Y-%m-%d`.sql /tmp/backup`date+%Y-%m-%d`
在crontab 中添加一行
#backup my database
2 0 * * * /var/local/mysqlback.sh >/dev/null 2>&1
2 0 * * * /var/local/mysqlback.sh >/dev/null 2>&1
转载于:https://blog.51cto.com/5680709/1097169