cd /usr/local/bin
vi backup.sh
#!/bin/bash
#mysql数据库逻辑备份脚本
#1.定义数据库连接和目标库信息
m_user=""
m_pass=""
m_port=""
m_host=""
m_conn="-P$m_port -u $m_user -p$m_pass -h $m_host"
m_db=""
#2.定义备份目录、工具、时间、文件名主体
bak_dir="/usr/local/mysql"
bak_cmd="/usr/local/mysql/bin/mysqldump"
bak_time=`date +%Y%m%d-%H%M`
name="$m_db-$bak_time"
cd $bak_dir
$bak_cmd $m_conn $m_db --skip-lock-tables |gzip > $name.sql.gz
crontab -e
#每天1点执行脚本文件
00 1 * * * /root/bin/backup.sh
#启动crontab服务
service crond start