linux mysql备份

#!/bin/sh
db_user=root
db_passwd=hyoa@123456
db_name=hyoa
# the directory for story your backup file.you shall change this dir
backup_dir="/usr/software/backup/mysqlbackup"
# date format for backup file (dd-mm-yyyy)
time="$(date +"%Y%m%d%H%M%S")"

mysqldump -E -R --triggers -u$db_user -p$db_passwd $db_name > "$backup_dir/$db_name"_"$time.sql"