备份数据库

#! /bin/bash
# This is a ShellScript For Auto DB Backup and Delete old Backup
#备份地址
backupdir=/root/currencyprod_dump
#备份文件后缀时间
time=_`date +%Y_%m_%d_%H_%M_%S`
#需要备份的数据库名称
db_name=currency_prod
#数据库地址
db_host=192.168.1.1
#mysql 用户名
db_user=root
#mysql 密码
db_pass=123456789
#端口
db_port=3306
/usr/bin/mysqldump -u$db_user -h$db_host -P$db_port  -p$db_pass --single-transaction --databases $db_name | gzip > $backupdir/$db_name$time.sql.gz