1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Whats your Backup Solution?

Discussion in 'Server Configuration and Hosting' started by seojoseph, Dec 29, 2013.

  1. seojoseph

    seojoseph Member


    I was wondering what your backup and recovery solution? Have you tested your recovery? Do you have a script to tar and download to another source? Just interested in some of the less extreme but effective solutions you've tried.
  2. nemke

    nemke Member

    My backups:

    1. First is by my VPS provider that happens every 3 days.
    2. Second is daily backup with duplicity and Amazon S3.
    3. Every 15 days, I have script that creates tar that I download and store on 2 different locations locally.
    seojoseph likes this.
  3. Moshe1010

    Moshe1010 Well-Known Member

    1. R1Soft
    2. Backupsy
    seojoseph and Mouth like this.
  4. Luke F

    Luke F Well-Known Member

    rdiff-backup + rdiffweb
    Adam Howard and seojoseph like this.
  5. RoldanLT

    RoldanLT Well-Known Member

    Same as eva.2000 suggested to me.
    But I haven't try it as I don't know where to start :D
  6. ehd

    ehd Active Member

    seojoseph likes this.
  7. Tracy Perry

    Tracy Perry Well-Known Member

    If you are referring to the VPS provider.... hopefully you won't have the problems I had with them when I cancelled service with them (since I no longer needed it). I cancelled about 2 months ago and still get hit on my card with a charge from them - and then have to jump through hoops to contact them, contact the bank (since I use a card that I keep a VERY low balance on until I transfer money into to make payments - it's a separate checking account). Last ticket I entered to them I notified them that it was going to start costing them $75 per hour 2 hour minimum if they processed any more charges. We'll see on the 15th when it normally hit.
    seojoseph likes this.
  8. Moshe1010

    Moshe1010 Well-Known Member

    I'm paying with PayPal. I never pay with credit/debit cards on unknown companies/websites, especially hosting. If they don't accept PayPal (rare), I generate virtual credit card numbers through citi/discover credit cards, and pay with them.
    seojoseph likes this.
  9. seojoseph

    seojoseph Member

    Bravo for that. I never heard of those. :) Thanks.
    Our new host; http://www.ramnode.com doesn't do backups very frequently. I wish they did. I might actually just try what @Luke Foreman suggested. :)
    hellreturn likes this.
  10. Luke F

    Luke F Well-Known Member

    rdiff-backup is pretty amazing, I've got daily backups going back months stored in less than 2x the size of a single backup, and with rdiffweb you can restore any revision of any file/folder in a dropbox-style web interface

    The only things it lacks are encryption (sure you can use something like encfs, but it has to be unlocked while backing up) and compression
    Wuebit, Adam Howard and seojoseph like this.
  11. seojoseph

    seojoseph Member

    How fast is the restore from a rdiffweb? its pretty quick?
    Last edited: Dec 29, 2013
  12. seojoseph

    seojoseph Member

  13. Amaury

    Amaury Well-Known Member

    I use phpMyAdmin. Although my last backup was on November 29, and I'm supposed to be taking backups once a week on Fridays. LOL
  14. Wuebit

    Wuebit Well-Known Member

    Was it easy to setup Dark?
  15. Adam Howard

    Adam Howard Well-Known Member

    ssh is your friend. :)

    mysqldump --opt -uUSERNAME -pPASSWORD DBNAME > /PATH/TO/backup-name-date.sql

    tar -zcvf Back-name-date.tar.gz /home/USER/public_html

    Download all the above.

    Of course if moving, I like to take 1 extra step and do at least a manual file download as well (on the safe side).

    And it should go without saying to never leave your backups on the server. Can't tell you how many people claim to have made a backup, yet never downloaded it and left it on the server.

    And for security, never have a backup inside /public_html/
    seojoseph likes this.
  16. seojoseph

    seojoseph Member

    ..and for those who don't know - Adam is pretty awesome. :)
    Adam Howard likes this.
  17. Alteran Ancient

    Alteran Ancient Well-Known Member

    I force myself to do a backup every Sunday night. It's usually quiet around then, so I can shut my forum for 10 minutes and do an SQL dump.

    If there was an idiot-proof means to dump a backup on schedule to an off-server location, that would be even better. Give me a month or so - my new professional job is going to involve Backup and Monitoring systems, so I may learn a thing or two.
    Adam Howard likes this.
  18. seojoseph

    seojoseph Member

    reading the documentation right now - rdiff-backup + rdiffweb seems like a solid solution. https://clientarea.ramnode.com/cart.php?gid=11 and $20 a year - so if he has months of backups for *2 of a normal tar.gz 50GB is way more then enough for me at least. Getting the flow down with the database backup still needs to happen but this direction seems like the right one for me.
  19. SneakyDave

    SneakyDave Well-Known Member

    That mysqldump command doesn't even include the host name. :rolleyes:

    The better, and much preferred mysql dump command from a script would look like:
    mysqldump -q -f -Q -e -h[HOSTNAME] -u[USERNAME] -p[DBPASSWORD] [DBNAME] | gzip > [BACKUP_PATH]/[DBNAME].1.sql.gz
    Last edited: Dec 29, 2013
  20. duderuud

    duderuud Active Member

Share This Page