You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.
#!/usr/bin/env bash
# 从本机 MySQL 导出完整数据（含询价记录）
# 用法：
# 依赖：
set -euo pipefail
ROOT = " $( cd " $( dirname " $0 " ) /../.. " && pwd ) "
OUT_DIR = " ${ ROOT } /deploy/database "
STAMP = " $( date +%Y%m%d-%H%M%S) "
OUT_FILE = " ${ OUT_DIR } /chajia-full- ${ STAMP } .sql "
if [ [ ! -f " ${ ROOT } /.env " ] ] ; then
echo " 缺少 ${ ROOT } /.env "
exit 1
fi
# shellcheck disable=SC1090
set -a
source " ${ ROOT } /.env "
set +a
if [ [ -z " ${ DATABASE_URL :- } " ] ] ; then
echo ".env 中未设置 DATABASE_URL"
exit 1
fi
if ! command -v mysqldump >/dev/null 2>& 1; then
echo "未找到 mysqldump，
exit 1
fi
# 解析 mysql://user:pass@host:port/db
if [ [ ! " $DATABASE_URL " = ~ mysql://( [ ^:] +) :( [ ^@] +) @( [ ^:/] +) :?( [ 0-9] *) /( [ ^?] +) ] ] ; then
echo " 无法解析 DATABASE_URL: $DATABASE_URL "
exit 1
fi
DB_USER = " ${ BASH_REMATCH [1] } "
DB_PASS = " ${ BASH_REMATCH [2] } "
DB_HOST = " ${ BASH_REMATCH [3] } "
DB_PORT = " ${ BASH_REMATCH [4] :- 3306 } "
DB_NAME = " ${ BASH_REMATCH [5] } "
mkdir -p " $OUT_DIR "
mysqldump \
" $DB_HOST " \
" $DB_PORT " \
" $DB_USER " \
" $DB_PASS " \
= utf8mb4 \
\
\
\
= OFF \
" $DB_NAME " > " $OUT_FILE "
gzip -kf " $OUT_FILE "
echo " 已导出: ${ OUT_FILE } "
echo " 已压缩: ${ OUT_FILE } .gz "
