Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Restorable backup script
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

Restorable backup script

Does anyone have a reliable and restorable backup script for use in debian? Or have a go to program they use.

I have 100gb backup storage with my dedicated server so will be transferring it off the server straight away

Thanked by 1perennate

Comments

  • SilvengaSilvenga Member
    edited August 2014

    I made a script a while ago using duplicity: https://gist.github.com/Silvenga/6835237

    It preforms a full backup every 3 weeks, incremental every night. It dumps the SQL tables to be as portable as possible. I have restored from the full backups it makes (it works!). I use Amazon's S3 for storage.

    EDIT: Ops, wrong script. This one I made for a friend to backup to Google Drive, I have a new one running on my servers using Amazon's S3.

    Thanked by 1linuxthefish
  • I use duply [http://duply.net]. It's a frontend over duplicity making it very simple to use.
    You can specify pre-backup and post-backup scripts, use s3 or ftp, specify a GPG key number for encryption ...

    Thanked by 1ginner159
  • With a simple site like WordPress, you can always dump the database and tar the files then rsync or lftp to other boxes.

  • can recommend Duply for making Duplicity easier to use.

    If you are going to use encryption (highly advise you so), please spend some time reading up on separate signing and encryption gpg keys, for additional security (you only need to store the signing private key + passphrase on the server you are backing up, that way).

    Thanked by 1ginner159
  • xavier66xavier66 Member
    edited August 2014

    Yes! Just generate a new key as root, and duply will store it automatically in the configuration directory.
    Then, you just need to backup /etc/duply/$profile to a different, secure location. When you wanna restore, just copy this folder over and run duply restore $profile $path.

    Btw, here is my pre script to backup mysql and postgresql databases :

    #!/bin/sh
    
    pg_dumpall -U postgres | gzip -c > /var/backups/pgsql.all.gz
    mysqldump --user backup --all-databases | gzip -c > /var/backups/mysql.all.gz
    

    Just create a "backup" user with select permission on all databases : http://wiki.zmanda.com/index.php/Pre-Installation#MySQL_Backup_User

    Thanked by 1ginner159
  • This is what we use, and it is very efficient:

    https://www.rfxn.com/projects/irsync-incremental-rsync/

    Thanked by 1ginner159
Sign In or Register to comment.