Backup MySQL databases in single file

How to dump existing MySQL databases on a server in a single file.

Mark van Eijk Updated 1 minute read Databases
  1. MySQL backup bash script
  2. How to use

MySQL backup bash script

A clear and simple bash script to export all MySQL databases on your server into separate .SQL files.

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 ./backup.sh.

Prefer a different layout? Back up each database to a separate file, exclude the system databases, or stream straight to an S3 bucket.