Backup MySQL databases in single file
How to dump existing MySQL databases on a server in a single file.
Published by Mark van Eijk on January 12, 2023 · 1 minute read
MySQL backup bash script
A clear and simple bash script to export all MySQL databases on your server into separate
With inline comments, this is the bash script to export all databases into separate files:
# MySQL username & password USER="" PASSWORD="" # MySQL dump options OPTIONS="--add-drop-table --extended-insert --single-transaction --skip-comments" mysqldump --user="$USER" --password="$PASSWORD" $OPTIONS --all-databases > ./databases.sql
How to use
You can use this by copying the script, save it in an
backup.sh file and then execute
chmod +x ./backup.sh to give the file execution permissions.
Execute the script with
Subscribe to our newsletter
Do you want to receive regular updates with fresh and exclusive content to learn more about web development, hosting, security and performance? Subscribe now!