Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@andmetoo

andmetoo/backup.sh

Created July 28, 2017 07:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andmetoo/1e8ddd612cdd4aefe6af85b4894ff1cc to your computer and use it in GitHub Desktop.
Save andmetoo/1e8ddd612cdd4aefe6af85b4894ff1cc to your computer and use it in GitHub Desktop.
Download ZIP
Mysql backup crontab
Raw
backup.sh
0 */6 * * * mysqldump --single-transaction --lock-tables=false -ubackup -pxp3VG9QceKMPdHYQXLqLbfigmKbn storm_pd1 | gzip -c | ./snapshot storm_pd1.sql.gz > ~/storm_pd1_dump.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment