MySQL Backup Script

mysql_backup.sh

#!/bin/bash
set -x # Debug Script

HOST=localhost
PASS=pass

# Additional options for review --opt --complete-insert --flush-logs --force --quote-names --add-drop-database --lock-tables --insert-ignore --comments
# See: http://www.iheavy.com/2012/08/09/5-things-you-overlooked-with-mysql-dumps/

#Structure Only
mysqldump --verbose --no-data --all-databases --complete-insert --skip-quote-names --hex-blob --host=$HOST -u root -p\"$PASS\" > db_schema_only_$HOST_`/bin/date +\%m\%d\%Y`.mysql

#Structure and Data
mysqldump --all-databases --compress --complete-insert --skip-quote-names --hex-blob --host=$HOST -u root -p\"$PASS\" > db_full_$HOST_`/bin/date +\%m\%d\%Y`.mysql