Skip to content

Instantly share code, notes, and snippets.

@cedricporter

cedricporter/backup_db.sh

Last active August 29, 2015 14:04
Show Gist options
  • Save cedricporter/50ce57a319ee8edb2314 to your computer and use it in GitHub Desktop.
Save cedricporter/50ce57a319ee8edb2314 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. cedricporter revised this gist Jul 17, 2014. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions backup_db.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -2,5 +2,7 @@

    # # m h dom mon dow user command
    # 30 4 * * 1,3,4 root /root/backup_db.sh
    # 41 4 * * 1,3,4 root /root/dropbox.py start
    # 57 4 * * 1,3,4 root /root/dropbox.py stop

    mysqldump -u root -p'password' --all-databases | gzip > /root/Dropbox/backups/mysql_bak/`date +%F`.sql.gz
  2. cedricporter created this gist Jul 17, 2014.
    6 changes: 6 additions & 0 deletions backup_db.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,6 @@
    #!/bin/sh

    # # m h dom mon dow user command
    # 30 4 * * 1,3,4 root /root/backup_db.sh

    mysqldump -u root -p'password' --all-databases | gzip > /root/Dropbox/backups/mysql_bak/`date +%F`.sql.gz