Skip to content

Instantly share code, notes, and snippets.

@tlongren

tlongren/backup-mysql.sh

Last active February 7, 2017 13:48
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save tlongren/85e0d7d04cd507b1ec53 to your computer and use it in GitHub Desktop.
Save tlongren/85e0d7d04cd507b1ec53 to your computer and use it in GitHub Desktop.
Download ZIP
Backup and Compress All Databases On Your MySQL Server
Raw
backup-mysql.sh
#!/bin/sh
rightnow=`date +%Y-%m-%d_%H-%M-%S`
/usr/bin/mysqldump -uroot -pyourpasswordfornoprompt --opt --all-databases --single-transaction | bzip2 -cq9 > /home/tyler/mysql-backups/full-$rightnow.sql.bz2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment