Skip to content

Instantly share code, notes, and snippets.

@mateuslopes
Created December 3, 2015 17:04
Show Gist options
  • Save mateuslopes/cfee59d77df0b5771a54 to your computer and use it in GitHub Desktop.
Save mateuslopes/cfee59d77df0b5771a54 to your computer and use it in GitHub Desktop.
ShellScript: Backup MySQL Database
#!/bin/sh
NOW=$(date +"%F")
sh -c "mysqldump -u <UserName> -p<Password> <DatabaseName> | gzip -9 > <DatabaseName>-$NOW.sql.gz"
echo "MYSQL DATABASE BACKUP GENERATED AT $NOW"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment