blob: 354818357fcbd0732162562c12786a85b87826f8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
#!/usr/bin/env bash
# Export clean schema (DDL only, no data) from current dev database
set -euo pipefail
# Add mysql-client to PATH (keg-only on macOS)
export PATH="/opt/homebrew/opt/mysql-client/bin:$PATH"
DB_HOST="127.0.0.1"
DB_PORT="3306"
DB_USER="beepzone_user"
DB_PASS="beepzone"
DB_NAME="beepzone"
echo "Exporting clean schema (DDL only, no data)..."
mysqldump \
--host="$DB_HOST" \
--port="$DB_PORT" \
--user="$DB_USER" \
--password="$DB_PASS" \
--no-data \
--skip-comments \
--skip-dump-date \
--skip-add-locks \
--skip-add-drop-table \
--skip-set-charset \
--skip-tz-utc \
--routines \
--triggers \
"$DB_NAME" | sed 's/ AUTO_INCREMENT=[0-9]*//g' > beepzone-schema-clean.sql
echo "✓ Exported to: beepzone-schema-clean.sql"
|
