19 lines
457 B
Bash
Executable File
19 lines
457 B
Bash
Executable File
#!/usr/bin/env bash
|
|
set -euo pipefail
|
|
|
|
DB_HOST="primary"
|
|
DB_PORT="3306"
|
|
DB_NAME="play-with"
|
|
DB_USER="root"
|
|
DB_PASSWORD="123456"
|
|
|
|
stamp="$(date +%F)"
|
|
backup_dir="yunpei/backup/dev/${stamp}"
|
|
mkdir -p "${backup_dir}"
|
|
|
|
echo "[backup] dumping ${DB_NAME} from ${DB_HOST}:${DB_PORT} -> ${backup_dir}/dev.sql.gz"
|
|
mysqldump -h "${DB_HOST}" -P "${DB_PORT}" -u "${DB_USER}" -p"${DB_PASSWORD}" "${DB_NAME}" \
|
|
| gzip > "${backup_dir}/dev.sql.gz"
|
|
|
|
echo "[backup] done"
|