Skip to content

Instantly share code, notes, and snippets.

@manniru
Forked from prcaen/gist:3413601
Created December 11, 2022 10:54
Show Gist options
  • Select an option

  • Save manniru/022aa885b174b883b268a5fd8aeec167 to your computer and use it in GitHub Desktop.

Select an option

Save manniru/022aa885b174b883b268a5fd8aeec167 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