Howdy, Stranger!

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


What is your backup method? - Page 2
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.

What is your backup method?

2»

Comments

  • mike1smike1s Member
    edited April 2021

    We use JetBackup for Web/Reseller hosting, and do nightly backups with a 5 day retention. All backups are sent offsite once a week. VPS are backed up using the builtin system on Proxmox, with nightly backups.

    Thanked by 1lucas01
  • CiprianoOscarCiprianoOscar Member, Host Rep

    @lucas01 said:
    Hi everyone,

    Can you suggest some backup methods?
    BTW I'm using cPanel.

    Thanks :)

    if I remember correctly, cpanel have automatic backup with FTP or SSH. You can easly find a vps with high storage and make daily backup without problems ;)

    Thanked by 1lucas01
  • angstromangstrom Moderator

    @darkimmortal said:
    Some people mentioning gzipped tar - worth keeping in mind that any corruption in these files causes loss of everything following the corruption. It’s not a particularly safe format once you get into the many GB region

    I use tar without gzip and it's worked well so far. You're right that adding gzip makes backups riskier.

    Thanked by 1darkimmortal
  • I put my truck in reverse.

    Thanked by 2doughnet themew
  • SplitIceSplitIce Member, Host Rep

    I've been backing up to Google Drive (workspaces) for years now. Check on it every 1-2 months. Works wonderfully.

  • AswinAswin Member, Host Rep

    I use restore manager - http://www.gk-root.com/ with own FTP storage for Cpanel servers, easy to backup and restore - incremental

  • bapbap Member
    edited April 2021

    me, rclone sync with --backup-dir

    I haven't try, but rclone supports ftp/sftp, if you have ftp/sftp on your cpanel enabled.

  • @darkimmortal said: Some people mentioning gzipped tar - worth keeping in mind that any corruption in these files causes loss of everything following the corruption. It’s not a particularly safe format once you get into the many GB region

    Luckily, in all my years haven't come across this but yeah it can happen. I've always focussed on backup/restore speed so sort of skipped verification part - only doing optional verification at restore time with optional verification at backup time (though rarely use for speed).

    I use xxhash checksum https://github.com/Cyan4973/xxHash as they're way faster than md5sum

    Example when running my backup script's auto generated MySQL database restore script to a staging MySQL database. The script will only proceed with restore if all xxhash checksum file verifications pass and are ok. Using zstd compression.

    I also have routines which can auto restore MySQL database backups to disposable MariaDB MySQL servers so I can do further in depth data comparisons with original database using other tools.

    time /home/mybackups/wp.example.com/mybackup/restore_wp1010429340db_17968_090421-042212_csv_staging.sh
    wp1010429340db_17968_090421-042212_csv.tar.zst: 92160 bytes                    
    csv_090421-042212/
    csv_090421-042212/13993_postmeta.txt
    csv_090421-042212/13993_commentmeta.sql
    csv_090421-042212/13993_terms.txt
    csv_090421-042212/13993_options.txt
    csv_090421-042212/13993_comments.txt
    csv_090421-042212/13993_term_taxonomy.txt
    csv_090421-042212/13993_users.txt
    csv_090421-042212/13993_terms.sql
    csv_090421-042212/13993_postmeta.sql
    csv_090421-042212/13993_usermeta.sql
    csv_090421-042212/13993_term_relationships.txt
    csv_090421-042212/13993_posts.txt
    csv_090421-042212/13993_usermeta.txt
    csv_090421-042212/13993_commentmeta.txt
    csv_090421-042212/13993_posts.sql
    csv_090421-042212/13993_term_taxonomy.sql
    csv_090421-042212/13993_users.sql
    csv_090421-042212/13993_options.sql
    csv_090421-042212/13993_comments.sql
    csv_090421-042212/13993_links.txt
    csv_090421-042212/13993_term_relationships.sql
    csv_090421-042212/13993_links.sql
    csv_090421-042212/13993_termmeta.txt
    csv_090421-042212/13993_termmeta.sql
    
    
    xxhsum -c csv_090421-042212.xxhash.checksum
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_commentmeta.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_commentmeta.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_comments.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_comments.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_links.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_links.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_options.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_options.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_postmeta.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_postmeta.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_posts.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_posts.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_termmeta.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_termmeta.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_relationships.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_relationships.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_terms.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_terms.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_taxonomy.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_taxonomy.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_usermeta.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_usermeta.txt: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_users.sql: OK
    /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_users.txt: OK
    
    
    wp1010429340db_17968_staging.13993_commentmeta: Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_comments: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_links: Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_postmeta: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_posts: Records: 3  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_options: Records: 133  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_termmeta: Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_terms: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_term_relationships: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_term_taxonomy: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_usermeta: Records: 15  Deleted: 0  Skipped: 0  Warnings: 0
    wp1010429340db_17968_staging.13993_users: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
    
    real    0m0.280s
    user    0m0.056s
    sys     0m0.031s
    
    
    diff compare original: wp1010429340db_17968 vs staging: wp1010429340db_17968_staging
    --- /dev/fd/63  2021-04-09 04:23:22.625508331 +0000
    +++ /dev/fd/62  2021-04-09 04:23:22.625508331 +0000
    @@ -1,4 +1,4 @@
    -Database: wp1010429340db_17968
    +Database: wp1010429340db_17968_staging
     +--------------------------+------------+----------+------------+
     |          Tables          | table_type | Columns  | Total Rows |
     +--------------------------+------------+----------+------------+
    
    real    0m0.347s
    user    0m0.093s
    sys     0m0.072s
    

    The xxhash checksum generated file contents for csv_090421-042212.xxhash.checksum created at backup time

    cat /home/mybackups/wp.example.com/mybackup/csv_090421-042212.xxhash.checksum
    0dc9910cd5cb27fb  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_commentmeta.sql
    ef46db3751d8e999  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_commentmeta.txt
    b5f925c5285b9dcb  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_comments.sql
    92d31771019f0a0d  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_comments.txt
    aba8d21a4f258bdb  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_links.sql
    ef46db3751d8e999  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_links.txt
    3f2f5cb6eaf504e2  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_options.sql
    b375ec9a7f662b0f  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_options.txt
    bcb9c4835c696dde  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_postmeta.sql
    e45782a05642dc11  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_postmeta.txt
    da74351216db3e12  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_posts.sql
    0c333e91c8bf3e70  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_posts.txt
    466864a469693327  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_termmeta.sql
    ef46db3751d8e999  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_termmeta.txt
    86896d1f6a606106  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_relationships.sql
    3d7f1d2d9f9d9bd1  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_relationships.txt
    a669319ed1ca79c8  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_terms.sql
    d27bae9121f01133  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_terms.txt
    46374deb37eaa91a  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_taxonomy.sql
    d1e1cadf7cd2bfd6  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_term_taxonomy.txt
    5db1a10bc5392981  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_usermeta.sql
    4698616da78172d9  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_usermeta.txt
    59f812beb9310ced  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_users.sql
    797fb30ea3fd5dc5  /home/mybackups/wp.example.com/mybackup/csv_090421-042212/13993_users.txt
    
  • Jetbackup is good

  • donkodonko Member

    @Aswin said:
    I use restore manager - http://www.gk-root.com/ with own FTP storage for Cpanel servers, easy to backup and restore - incremental

    ssl broken on site and using whmcs nulled?, yes looks very trustable

  • AswinAswin Member, Host Rep

    @donko said:

    @Aswin said:
    I use restore manager - http://www.gk-root.com/ with own FTP storage for Cpanel servers, easy to backup and restore - incremental

    ssl broken on site and using whmcs nulled?, yes looks very trustable

    Have been using it for many servers and cost-wise $3 per month, very cheap. We have to keep the files in our own storage since it is trustable.

  • jetbackup

  • pbxpbx Member

    @its420somewhere said: I backup my most important files to /dev/null twice daily. Greatest success.

    That's the best solution as it uses very little bandwidth and CPU power + you don't need external storage space.

    If CPU, bandwidth and external storage space are not a problem for you, I'd definitely recommend Borg.

    Thanked by 1its420somewhere
  • Backup in the same physical datacenter with private network. I think I am safe.

  • pbxpbx Member

    @elliotc said: I think I am safe.

    BEWARE OF WOODEN FLOORS!

  • skorupionskorupion Member, Host Rep

    Cyberpanel FTP to unused racknerd server to my one drive student account

    Thanked by 1dustinc
  • @elliotc said: Backup in the same physical datacenter with private network. I think I am safe.

    oEmJI

  • @pbx said: BEWARE OF WOODEN FLOORS!

    And old generators.

    Thanked by 1pbx
  • Depends on what it is.

    Kubernetes play thing, PV gets backed up to B2 daily
    Proxmox servers - Backup to Proxmox backup server (in a different DC)
    Linux Servers/VM's (Not on a proxmox host) - Restic or Proxmox backup client.

    My Desktop, rarely bother it's mostly games on it anyway.

    Thanked by 2pbx lucas01
  • @donko said:

    @Aswin said:
    I use restore manager - http://www.gk-root.com/ with own FTP storage for Cpanel servers, easy to backup and restore - incremental

    ssl broken on site and using whmcs nulled?, yes looks very trustable

    If you checked it the day before the cert expired, it would have been valid. So you can add, "three days and they still don't realize their cert expired". I've contacted companies before and its usually, "the certificate renewed but the cronjob failed to restart the web server". So? Do your fucking job properly and it wouldn't be an issue.

Sign In or Register to comment.