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