mysql 实现每天数据库备份数据 .sh
refer: http://siwei.me/blog/posts/backup_db-sh
使用.sh文件进行数据库的数据库每天进行备份，例如：（修改好参数就可以使用了。）
<span style="color:#f5ab35">#!/bin/bash</span>
<span style="color:#d4d0ab"># 设置备份目录和文件名</span>
backup_dir=<span style="color:#abe338">"/path/to/backup/directory"</span>
backup_file=<span style="color:#abe338">"</span><span style="color:#ffa07a">$backup_dir</span><span style="color:#abe338">/db_backup_</span><span style="color:#abe338">$(date +%Y%m%d)</span><span style="color:#abe338">.sql"</span>
<span style="color:#d4d0ab"># MySQL 连接参数</span>
db_host=<span style="color:#abe338">"localhost"</span>
db_port=<span style="color:#abe338">"3306"</span>
db_name=<span style="color:#abe338">"your_database"</span>
db_user=<span style="color:#abe338">"your_username"</span>
db_password=<span style="color:#abe338">"your_password"</span>
<span style="color:#d4d0ab"># 创建备份目录</span>
mkdir -p <span style="color:#abe338">"</span><span style="color:#ffa07a">$backup_dir</span><span style="color:#abe338">"</span>
<span style="color:#d4d0ab"># 执行备份命令</span>
mysqldump -h <span style="color:#abe338">"</span><span style="color:#ffa07a">$db_host</span><span style="color:#abe338">"</span> -P <span style="color:#abe338">"</span><span style="color:#ffa07a">$db_port</span><span style="color:#abe338">"</span> -u <span style="color:#abe338">"</span><span style="color:#ffa07a">$db_user</span><span style="color:#abe338">"</span> -p<span style="color:#abe338">"</span><span style="color:#ffa07a">$db_password</span><span style="color:#abe338">"</span> <span style="color:#abe338">"</span><span style="color:#ffa07a">$db_name</span><span style="color:#abe338">"</span> > <span style="color:#abe338">"</span><span style="color:#ffa07a">$backup_file</span><span style="color:#abe338">"</span>
<span style="color:#d4d0ab"># 输出备份完成信息</span>
<span style="color:#f5ab35">echo</span> <span style="color:#abe338">"数据库备份完成：</span><span style="color:#ffa07a">$backup_file</span><span style="color:#abe338">"</span>
<span style="color:#d4d0ab"># 等待 24 小时</span>
sleep 24h
<span style="color:#d4d0ab"># 执行脚本本身，实现每天的定时执行</span>
/path/to/daily_backup.sh