#!/bin/bash
db_user="username"
db_passwd="password"
db_name="tableName"
# the directory for story your backup file.you shall change this dir
backup_dir="/opt/data/backup/"
# date format for backup file (dd-mm-yyyy)
time="$(date +"%Y%m%d%H%M%S")"
mysqldump -u$db_user -p$db_passwd $db_name > "$backup_dir/$db_name"_"$time.sql"
MySql数据备份脚本
最新推荐文章于 2024-06-16 01:17:44 发布