环境运维

mysqldump 定时备份mysql数据库

#!/bin/bash

backup_dir="/home/data_bak"
backup_file="${backup_dir}/backup_$(date +'%Y%m%d%H%M%S')"
sql_file="${backup_file}.sql"
zip_file="${backup_file}.tar.gz"
mysqldump -h服务器ip -u数据库用户名 -p密码 数据库名 > ${sql_file}

tar -zcvf ${zip_file} ${sql_file}
rm -f ${sql_file}

=========================

定时:

执行 crontab -e命令

输入 

0 0 * * *  /home/mysqlback.sh

输入:wq保存退出

 

 

=================

可能的报错
~
~
~

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
tar: Removing leading `/' from member names