mysql数据备份命令行脚本

mysql数据备份命令行脚本

Linux系统根据下面配置脚本生成数据库备份脚本：

#!/bin/bash

read -p "存放备份的目录(默认路径/opt/mysql_backup) :" back_dir
test -z "$back_dir" && back_dir=/opt/mysql_backup
echo "备份目录为：: $back_dir"

read -p "MySQL的bin目录(默认路径/usr/local/mysql/bin) :" mysql_bin
test -z "$mysql_bin" && mysql_bin=/usr/local/mysql/bin
echo "MySQL的bin目录为: $mysql_bin"

read -p "要备份的数据库IP地址(默认地址 127.0.0.1):" database_host
test -z "$database_host" && database_host=127.0.0.1
echo "数据库地址为: $database_host"

read -p "数据库用户名: " username
echo "数据库用户名: $username"

read -p "数据库密码: " password
echo "数据库密码为: $password"

test ! -d "${back_dir}" && mkdir -p "${back_dir}"
test ! -d "${back_dir}/mysql_back.sh" && touch "${back_dir}/mysql_back.sh"
chmod +x ${back_dir}/mysql_back.sh

cat << EOF > $back_dir/mysql_back.sh
#!/bin/bash
###backup info
db_host=${database_host}
user=${username}
passwd=${password}
keepdate=\`date +%Y%m%d --date="-7 day"\`
expirdate=\`date +%Y%m%d --date="-15 day"\`

####MySQL info
backdate=\`date +%Y%m%d\`
datadir="${back_dir}"
backdir="\${datadir}/\${backdate}"
mysqldir="${mysql_bin}/mysql"
dumpdir="$mysql_bin/mysqldump"
errlog="\${...

点击查看剩余70%