Skip to content

Instantly share code, notes, and snippets.

#!/bin/bash
# This script will backup all mysql databases into
# compressed file named after date, ie: /var/backup/mysql/2024-05-09_07:00.zip
# Setup variables used later
# Create date suffix with "F"ull date format and add hour:time
suffix=$(date +%F_%H:%M)
# Create temporary directory with "-d" option
@PassiHD2004
PassiHD2004 / mysql-db-backup.sh
Last active May 9, 2024 05:13
Mysql backup script for all databases into zip file
#!/bin/bash
# Authors:
# - https://stackoverflow.com/users/5444623/peterm (original script)
# - https://github.com/PassiHD2004 (improvements)
# This script will backup all mysql databases into
# compressed file named after date, ie: /var/backup/mysql/2024-05-09_07:00.zip
# Setup variables used later