A BASH script to export all MySQL databases to individual files and another to import the files back to MySQL. Adapted from http://stackoverflow.com/a/26096339/3299349 and https://gist.github.com/tenold/aa5e107d93c0f54436cb

export-mysql.sh

#!/bin/bash

USER="root"

ExcludeDatabases="Database|information_schema|performance_schema|mysql"
databases=`mysql -u $USER -e "SHOW DATABASES;" | tr -d "| " | egrep -v $ExcludeDatabases`

for db in $databases; do
	echo "Dumping database: $db"
	mysqldump -u $USER --databases $db > `date +%Y%m%d`.$db.sql
	gzip `date +%Y%m%d`.$db.sql
done

import-mysql.sh

#!/bin/bash

USER="root"

FILES='./*.gz ./*.sql'

for f in $FILES
do
	if file --mime-type "$f" | grep -q gzip$; then
		echo "Processing gzipped: $f"
		gzcat $f | mysql -u $USER
	else
		echo "Processing: $f"
		mysql -u $USER < $f
	fi
done

To Use

1. Download these scripts into a folder that will contain backups.
2. Update ExcludeDatabases in export-mysql.sh to exclude any additional databases.
3. Open a terminal window and cd into the folder.
4. Make these scripts executable by typing chmod +x export-mysql.sh & chmod +x import-mysql.sh.
5. Execute by typing ./export-mysql.sh or ./import-mysql.sh