| DB_HOST= | |
| DB_DATABASE= | |
| DB_USERNAME= | |
| DB_PASSWORD= |
Simple Database backup and restore command for database which is running in Docker
db.sh and .env.example..env.example to .env if .env does not exist.bash db.sh -b
OR
bash db.sh --backup
bash db.sh -r
OR
bash db.sh --restore
| #!/bin/bash | |
| set -e | |
| source .env | |
| BASE_PATH=$(dirname $0) | |
| BACKUP_DIR=$BASE_PATH/backup | |
| BACKUP_TIME=$(date +%Y%m%d-%H%M%S) | |
| FILE_NAME=${DB_DATABASE}_${BACKUP_TIME}.sql | |
| MODE=$1 | |
| [ -d ${BACKUP_DIR} ] || mkdir ${BACKUP_DIR} | |
| if [[ "$MODE" == "--backup" || "$MODE" == "-b" ]]; then | |
| docker exec ${DB_HOST} /usr/bin/mysqldump -u ${DB_USERNAME} --password=${DB_PASSWORD} ${DB_DATABASE} > $BACKUP_DIR/$FILE_NAME | |
| echo "Creating back up file $BACKUP_DIR/$FILE_NAME" | |
| echo "Database was backed up successfully." | |
| elif [[ "$MODE" == "--restore" || "$MODE" == "-r" ]]; then | |
| cat $BACKUP_DIR/$FILE_NAME | docker exec -i ${DB_HOST} /usr/bin/mysql -u ${DB_USERNAME} --password=${DB_PASSWORD} ${DB_DATABASE} | |
| echo "Restoring the database from file $BACKUP_DIR/$FILE_NAME" | |
| echo "Database was restored successfully." | |
| else | |
| echo -e "Supported options:" | |
| echo -e "-b|--backup\tBackup database" | |
| echo -e "-r|--restore\tRestore database" | |
| fi | |
| echo "Exiting..." | |
| exit 0 |