备份 mysql 数据库脚本
#!/bin/sh
# File: /home/mysql/backup.sh
# Database info bakupmysql
DB_USER="user"
DB_PASS="password"
# Others vars
DATE=`date +%Y-%m-%d`
# 备份目录
mkdir /home/mysqlbak/$DATE
BIN_DIR="/usr/local/mysql/bin"
BCK_DIR="/home/mysqlbak/$DATE"
# TODO 备份命令
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS discuz > $BCK_DIR/discuz.sql
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS zjblog > $BCK_DIR/zjblog.sql
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS openads > $BCK_DIR/openads.sql
备份 mysql 数据库脚本
最新推荐文章于 2024-08-01 15:48:01 发布