Skip to content

Instantly share code, notes, and snippets.

@prcaen
Created August 21, 2012 08:41
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save prcaen/3413601 to your computer and use it in GitHub Desktop.
Save prcaen/3413601 to your computer and use it in GitHub Desktop.
Backup database periodically
# At 9, 13, 16 and 19 hour every monday, tuesday, wednesday, thursday and friday
* 9,13,16,19 * * 1,2,3,4,5 root /Applications/XAMPP/xamppfiles/bin/mysqldump -u root --all-databases | gzip > /Users/pierrick/Documents/Backups/Sites/database_`date +"%m_%d_%Y_%H_%M"`.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment