Skip to content

Instantly share code, notes, and snippets.

@nfhipona
Last active July 19, 2020 05:12
Show Gist options
  • Save nfhipona/faf2d7bf19ccd03330895b3f4d387c27 to your computer and use it in GitHub Desktop.
Save nfhipona/faf2d7bf19ccd03330895b3f4d387c27 to your computer and use it in GitHub Desktop.
Crontab - mysqldump
crontab schedule:
30 23 * * * mysqldump -hhost -uuser -ppassword dbname --single-transaction --quick --lock-tables=false > ..location/filename-backup-`date "+\%F"`.sql
running script
30 23 * * 7 /home/ubuntu/scripts/./bash_script.sh
manual dump bash
mysqldump -hhost -uuser -ppassword dbname --single-transaction --quick --lock-tables=false > ..location/filename-backup-`date '+%F'`.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment