Welcome to Centmin Mod Community
Become a Member

Centminmod based server and Backupsy, What is the most ideal way to backup?

Discussion in 'Virtual Private Server (VPS) hosting' started by RoldanLT, Nov 5, 2014.

Tags:
  1. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    What kind of backup method did you use?
    rsnapshot, rsync, etc..
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1
  3. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    rsnapshot already take care both files and mysql database?
    Is there any basic guide how to implement that?

    Thanks Eva!
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    nope you need to have you own mysql database backup script to backup to sql files on your server and then use rsnapshot to point to directories you want backed up including the directory containing your mysql backup sql files.

    You're on your own but plenty of centos + rsnapshot guides via google :D + official how to at rsnapshot.org/howto/1.2/rsnapshot-HOWTO.en.html (difference is no need to source compile rsnapshot just use yum install rsnapshot)
     
    • Like Like x 1
  5. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    Yes I already have in place :)
    For the last several months I'm using Dropbox though :D
    But out of capacity, only database is uploaded there daily.
     
  6. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    you don't care about files ? attachments ? you should backup database and files together :)

    doesn't dropbox have a 1TB plan now ? :D
     
    • Like Like x 1
  7. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    I care that's why I'm seeking of another way other than Dropbox.
    Cause I only have 7GB+ storage on Dropbox, Forum files is not enough on that space.
    Maybe backupsy will work for me, need to study on how to properly setup rsnapshot first.
     
  8. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah I use backupsy 500GB VPS plan and pay extra $2/month for full VPS usage instead of just backup only. Install Centmin Mod on the server so it acts as both VPS web server and backup server fully protected by CSF Firewall and all :)

    just install rsnapshot via yum and not source as directed in how to on official site and then proceed with steps 4, 5 and 6 at rsnapshot HOWTO
     
  9. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
  10. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    perfect.. was going to say step 4.3 at rsnapshot HOWTO for changing default snapshot storage directory, but that guide explains it all :) Just remember if you have CSF Firewall on either source and/or backup servers, to whitelist IP addresses

    still good read of how rsnapshot works at rsnapshot HOWTO
     
    • Like Like x 1
  11. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    Need to install that on both server right?
     
  12. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    install what ? rsnapshot is only needed on backup server = backupsy server

    rsnapshot is pull based backups - so it connects to your origin server and transfers backup directories and files you configure rsnapshot to backup
     
    • Like Like x 1
  13. Andy

    Andy Active Member

    333
    48
    28
    Aug 6, 2014
    Ratings:
    +57
    Local Time:
    11:11 PM
    I have a Synology NAS, does anyone know how do I can backup my db/files on the backup folder?
     
  14. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    never used Synology NAS myself but if you have SSH, ftp/sftp or something probably it's just like any Linux server ?
     
  15. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    Following this guide: How to Install Rsnapshot on Ubuntu 12.04 | DigitalOcean
    On this part:
    Code:
    sudo ssh-copy-id -i /root/.ssh/id_rsa.pub root@example.com
    How can I append my custom port properly?
    I tried some commands I know but not working :/

    1234 is custom port of my server wnat to backup and 123.123.12.12 is the IP address.
    Code:
    root@install:~# sudo ssh-copy-id -i /root/.ssh/id_rsa.pub 'ssh -p 1234' root@123.123.12.12
    ssh: Could not resolve hostname ssh: Name or service not known
    root@install:~# sudo ssh-copy-id -i /root/.ssh/id_rsa.pub '-p 1234' root@123.123.12.12
    Pseudo-terminal will not be allocated because stdin is not a terminal.
    ssh: Could not resolve hostname umask 077; test -d ~/.ssh || mkdir ~/.ssh ; cat >> ~/.ssh/authorized_keys: Name or service not k       nown
    root@install:~# sudo ssh-copy-id -i /root/.ssh/id_rsa.pub -p 1234 root@123.123.12.12
    Bad port 'umask 077; test -d ~/.ssh || mkdir ~/.ssh ; cat >> ~/.ssh/authorized_keys'
    root@install:~#
     
  16. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    Got it now with
    sudo ssh-copy-id -i /root/.ssh/id_rsa.pub "root@123.123.12.12 -p 1234"
    :)
     
  17. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    Code:
    ssh-copy-id -i ~/.ssh/id_rsa.pub "root@sourceserveripaddress -p 22"
    :)
     
    • Like Like x 1
  18. eva2000

    eva2000 Administrator Staff Member

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    2:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    Heh posted at same time :D
     
    • Like Like x 1
  19. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    Should be merge or consider double post, LoL
    Thanks Eva!
     
  20. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:11 PM
    1.11
    10.2
    Now on this part:
    Code:
    sudo ssh root@example.com
    How can I append my custom port again? :(
    Old method is not working.