Last active
April 18, 2020 19:37
-
-
Save nicoverbruggen/5ca2213591b2238f5400f2bf7597083f to your computer and use it in GitHub Desktop.
Dump database file
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[mysqldump] | |
user=root | |
password=INSERT_PASSPHRASE_HERE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Take a backup of the database with dumpie every day at midnight (0:00) | |
0 0 * * * /home/nico/utils/dumpie > /home/nico/dumpie.log | |
# Take a backup with Aegis every Sunday at 1:00 | |
0 1 * * 0 /home/nico/aegis/aegis backup:dropbox /home/nico/aegis/jobs/backup.yaml > /home/nico/aegis.log |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
rm /var/www/nicoverbruggen.be/storage/dump.sql; | |
echo "Dumping database of nicoverbruggen.be..."; | |
mysqldump nicoverbruggen > /var/www/nicoverbruggen.be/storage/dump.sql; | |
echo "Done."; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment