1、新建备份目录
mkdir /usr/local/mysql/back
2、新建备份脚本 且授权
vi /usr/local/mysql/dbback.sh
#!/bin/sh
home=/usr/local/mysql
now=`date +%Y%m%d`
cd $home/back
echo "You are in backup dir:" $home
#echo $home/back/$now
$home/bin/mysqldump -uusername -ppasswd xxx> $home/back/$now.sql
echo "Your database backup successfully completed"
chmod u+x /usr/local/mysql/dbback.sh
[备份所有数据且压缩命令]
mysqldump -hip -Pport -uusername -ppassword --all-databases | gzip> filename.sql.gz
3、linux定时执行程序
crontab -e
*/5 * * * * /usr/local/mysql/dbback.sh
#查看定时程序内容
crontab -l
#如果定时程序没有安装,安装命令
yum -y install vixie-cron