Skip to content

Instantly share code, notes, and snippets.

@githubber

githubber/backup.sh

Forked from n2j3/backup.sh
Created September 16, 2016 12:15
Show Gist options
  • Save githubber/a0fc2b20fe8f820d23c9fac87574f33d to your computer and use it in GitHub Desktop.
Save githubber/a0fc2b20fe8f820d23c9fac87574f33d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @n2j3 n2j3 revised this gist Mar 31, 2013. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions backup.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -15,8 +15,8 @@ DESTFILE="$BACKUP_DST/$NOW.tgz"
    mysqldump -u $MYSQL_USER -h $MYSQL_SERVER -p$MYSQL_PASS --all-databases > "$NOW-Databases.sql"
    tar cfz "$DESTFILE" $BACKUP_SRC "$NOW-Databases.sql"

    #upload to dropbox. dropbox_uploader has to be in your $PATH
    dropbox_uploader.sh upload "$DESTFILE"
    #upload to dropbox. make sure the following line points to the correct dropbox_uploader.sh location
    /root/dropbox_uploader.sh upload "$DESTFILE"

    #remove temporary files
    rm -f "$NOW-Databases.sql" "$DESTFILE"
  2. @n2j3 n2j3 revised this gist Mar 30, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion backup.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -15,7 +15,7 @@ DESTFILE="$BACKUP_DST/$NOW.tgz"
    mysqldump -u $MYSQL_USER -h $MYSQL_SERVER -p$MYSQL_PASS --all-databases > "$NOW-Databases.sql"
    tar cfz "$DESTFILE" $BACKUP_SRC "$NOW-Databases.sql"

    #upload to dropbox
    #upload to dropbox. dropbox_uploader has to be in your $PATH
    dropbox_uploader.sh upload "$DESTFILE"

    #remove temporary files
  3. @n2j3 n2j3 revised this gist Mar 30, 2013. 1 changed file with 4 additions and 1 deletion.
    5 changes: 4 additions & 1 deletion backup.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -4,16 +4,19 @@ BACKUP_DST="/tmp"
    MYSQL_SERVER="127.0.0.1"
    MYSQL_USER="mysql username"
    MYSQL_PASS="mysql password"
    #VPS_ID="vpsidentifier"

    #
    # Stop editing here.
    NOW=$(date +"%Y.%m.%d")
    DESTFILE="$BACKUP_DST/$NOW.tgz"
    #DESTFILE="$BACKUP_DST/$VPS_ID.$NOW.tgz

    # Backup files.
    mysqldump -u $MYSQL_USER -h $MYSQL_SERVER -p$MYSQL_PASS --all-databases > "$NOW-Databases.sql"
    tar cfz "$DESTFILE" $BACKUP_SRC "$NOW-Databases.sql"

    #upload to dropbox
    dropbox_uploader.sh upload "$DESTFILE"

    #remove temporary files
    rm -f "$NOW-Databases.sql" "$DESTFILE"
  4. @n2j3 n2j3 created this gist Mar 30, 2013.
    19 changes: 19 additions & 0 deletions backup.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,19 @@
    #!/bin/bash
    BACKUP_SRC="/root /etc /home"
    BACKUP_DST="/tmp"
    MYSQL_SERVER="127.0.0.1"
    MYSQL_USER="mysql username"
    MYSQL_PASS="mysql password"

    #
    # Stop editing here.
    NOW=$(date +"%Y.%m.%d")
    DESTFILE="$BACKUP_DST/$NOW.tgz"

    # Backup files.
    mysqldump -u $MYSQL_USER -h $MYSQL_SERVER -p$MYSQL_PASS --all-databases > "$NOW-Databases.sql"
    tar cfz "$DESTFILE" $BACKUP_SRC "$NOW-Databases.sql"

    dropbox_uploader.sh upload "$DESTFILE"

    rm -f "$NOW-Databases.sql" "$DESTFILE"