Sha256: f38cc811763c983bc79c0b7e657f8cc0bc5933b5bb6892cf3d30db5ddb2c691b
Contents?: true
Size: 574 Bytes
Versions: 7
Compression:
Stored size: 574 Bytes
Contents
#!/bin/bash
db_host_string=$(cat .env | grep WORDPRESS_DB_HOST)
db_host=${db_host_string#*=}
db_root_string=$(cat .env | grep MYSQL_ROOT_PASSWORD)
root_pw=${db_root_string#*=}
db_name_string=$(cat .env | grep WORDPRESS_DB_NAME)
db_name=${db_name_string#*=}
mysql_path_string=$(cat .env | grep MYSQL_DUMP_DIR)
mysql_path=${mysql_path_string#*=}
dump_name=${mysql_path}/${db_name}.`date +%Y%m%d%H%M%S`.gz
docker-compose exec ${db_host} /usr/bin/mysqldump --single-transaction --no-tablespaces --skip-lock-tables -u root -p${root_pw} ${db_name} | gzip -9 > ${dump_name}
Version data entries
7 entries across 7 versions & 1 rubygems