linux 本地mysql定期备份

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