Skip to content

Instantly share code, notes, and snippets.

@timilsinabishal

timilsinabishal/mysql_docker_backup.sh

Created October 24, 2024 10:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save timilsinabishal/09442ad1a8e6bac4f265223aa1906c20 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save timilsinabishal/09442ad1a8e6bac4f265223aa1906c20 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_docker_backup.sh
#!/bin/bash
CONTAINER_ID="mysql"
DB_USER="root"
DB_PASSWORD="pass"
DB_NAME="postgres"
BACKUP_DIR="/home/root/db_dumps/"
BACKUP_FILE=dump_`date +%Y-%m-%d"_"%H_%M_%S`.sql.gz
echo $(date -u) "Deleting backups older than 30 days inside dir $BACKUP_DIR"
find $BACKUP_DIR -type f -name "*.gz" -mtime +30 -delete
echo $(date -u) "Successfully deleted old backups"
echo $(date -u) "Starting backup of database $DB_NAME"
docker exec -t $CONTAINER_ID /usr/bin/mysqldump -u $DB_USER --password=$DB_PASSWORD $DB_NAME | gzip > $BACKUP_DIR$BACKUP_FILE
echo $(date -u) "Backup completed"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment