11 lines
235 B
Bash
11 lines
235 B
Bash
#!/bin/bash
|
|
|
|
|
|
DB_HOST="127.0.0.1"
|
|
DB_NAME="dbname"
|
|
DB_USER="dbuser"
|
|
DB_PASSWORD="123456"
|
|
DUMP_FILE=${DB_NAME}_dump_$(date -d "today" +"%Y%m%d%H%M%S").sql
|
|
mysqldump -v -h $DB_HOST --user=$DB_USER -p"$DB_PASSWORD" $DB_NAME > $DUMP_FILE
|
|
|