mysql_backup.sh

#!/bin/bash

DATE=`date +%Y-%m-%d_%H-%M-%S`
cd "/vagrant/backups/"
mkdir $DATE && cd $_
for i in `mysql -u root -psecret -e "show databases;" | grep -Ev "^(Database|mysql|performance_schema|information_schema)$"`; do
	echo "dumping ${i}"
    sudo mysqldump -c -u root -psecret ${i} > ${i}.sql
done

mysql_restore.sh

#!/bin/bash

for f in *.sql
do
	filename=$(basename "$f")
	extension="${filename##*.}"
	table="${filename%.*}"
	echo Restoring $filename to $table
	mysql --login-path=local $table < $f
done