Habilis Posted May 5, 2017 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 31 Reputation: 14 Joined: 06/13/16 Last Seen: October 28, 2018 Share Posted May 5, 2017 It is a custom backup solution I've been working on, Thanks to feedback of community, I managed to make a V2 V2 of my Database Backup solution Featuring 1. generate a backup of databases specified in a list 2. Name them with yyy-mm-dd[DatabaseName] format 3. Compress them into .7z using maximum compression 4. Set a password on .7z archive 5. Send them to cloud storage Google Drive 6. Write logs 7. Removes all compressed backups 28 days or older (keeping local folder nice and clean) 8. Can be automated with cron to run even every 12 hours Ow yeah, Don't worry about someone hacking your GoogleDrive, if you put 14 character+ Alphanumeric password on yout backup archives it is going to be bruted loong time... 3 Quote Link to comment Share on other sites More sharing options...
sikiro Posted May 5, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 171 Reputation: 16 Joined: 01/26/12 Last Seen: January 1, 2024 Share Posted May 5, 2017 (edited) this is amazing. specaily for someone using onedrive. Edited May 5, 2017 by sikiro Quote Link to comment Share on other sites More sharing options...
Habilis Posted May 5, 2017 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 31 Reputation: 14 Joined: 06/13/16 Last Seen: October 28, 2018 Author Share Posted May 5, 2017 (edited) 5 minutes ago, sikiro said: this is an amazing guide +1 is google drive the only option to upload to can someone use box or one-drive for example? Thanks for the +1! Absolutely not only Google Drive, in the guide I provide a link to rclone github, cool guys, you should check them out! https://github.com/ncw/rclone They have a list of all remote options supported (If you are by any chance Russian, they Even support Yandex Disk, amazing isn't it?) Quote Google Drive Amazon S3 Openstack Swift / Rackspace cloud files / Memset Memstore Dropbox Google Cloud Storage Amazon Drive Microsoft OneDrive Hubic Backblaze B2 Yandex Disk SFTP The local filesystem Edited May 5, 2017 by Habilis Quote Link to comment Share on other sites More sharing options...
sikiro Posted May 5, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 171 Reputation: 16 Joined: 01/26/12 Last Seen: January 1, 2024 Share Posted May 5, 2017 so your guide will work reguardless of what i pick tho right? Quote Link to comment Share on other sites More sharing options...
Habilis Posted May 5, 2017 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 31 Reputation: 14 Joined: 06/13/16 Last Seen: October 28, 2018 Author Share Posted May 5, 2017 Yes, I don't see why it wouldn't. It's just the matter of being able to configure your favorite remote cloud service with rclone. Quote Link to comment Share on other sites More sharing options...
sikiro Posted May 5, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 171 Reputation: 16 Joined: 01/26/12 Last Seen: January 1, 2024 Share Posted May 5, 2017 (edited) yeah works great only hicup is i only allow ssh for my remote server so when getting the authentication code im stuck unless i use interface unless you know a way to do it on putty. and p7zip on centos 7 doesnt seem to be available. Edited May 5, 2017 by sikiro Quote Link to comment Share on other sites More sharing options...
Habilis Posted May 5, 2017 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 31 Reputation: 14 Joined: 06/13/16 Last Seen: October 28, 2018 Author Share Posted May 5, 2017 (edited) Of course! I did mine in Putty. When it gives you the link to goto you highlight it and right-click. (it is paste in putty) this will paste the link in the console, erase it. But it will also copy it. Now you can paste it in your browser CTRL+V on Wind0z machine and authenticate Then copy CTRL+C the Verification code and right-click in putty to paste it. Edited May 5, 2017 by Habilis 1 Quote Link to comment Share on other sites More sharing options...
sikiro Posted May 5, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 171 Reputation: 16 Joined: 01/26/12 Last Seen: January 1, 2024 Share Posted May 5, 2017 (edited) got it thank you! Suggestion for this would be nice to be able to backup emulator as well. Edited May 5, 2017 by sikiro Quote Link to comment Share on other sites More sharing options...
Habilis Posted May 5, 2017 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 31 Reputation: 14 Joined: 06/13/16 Last Seen: October 28, 2018 Author Share Posted May 5, 2017 (edited) Ow sorry I didn't see about 7zip on CentOS wget https://www.mirrorservice.org/sites/dl.fedoraproject.org/pub/epel/6/x86_64/p7zip-16.02-1.el6.x86_64.rpm sudo rpm -U --quiet p7zip-16.02-1.el6.x86_64.rpm The guide is actually for Debian / Ubuntu systems, well if you manage to get it working on CentOS, It would be awesome! Edited May 5, 2017 by Habilis Quote Link to comment Share on other sites More sharing options...
sikiro Posted May 5, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 171 Reputation: 16 Joined: 01/26/12 Last Seen: January 1, 2024 Share Posted May 5, 2017 it worked perfectly fine on centos for 7zip you need to install the plugins for it on centos 7 or it will not function is it posible to make it so that you can backup the emulator as well? Quote Link to comment Share on other sites More sharing options...
Habilis Posted May 5, 2017 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 31 Reputation: 14 Joined: 06/13/16 Last Seen: October 28, 2018 Author Share Posted May 5, 2017 Unfortunately, I'm not a CentOS guy, try 7zip without plugins. And yes it's absolutely possible to backup Emulator as well. Just Google it up how to add a folder to archive and send it to Cloud with rclone as well. Quote Link to comment Share on other sites More sharing options...
sikiro Posted May 5, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 171 Reputation: 16 Joined: 01/26/12 Last Seen: January 1, 2024 Share Posted May 5, 2017 no im saying it works if u use the plugins its working perfectly right now. Quote Link to comment Share on other sites More sharing options...
Habilis Posted May 5, 2017 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 31 Reputation: 14 Joined: 06/13/16 Last Seen: October 28, 2018 Author Share Posted May 5, 2017 Ah ok, Cool! Quote Link to comment Share on other sites More sharing options...
Secrets Posted May 6, 2017 Group: Developer Topic Count: 36 Topics Per Day: 0.01 Content Count: 588 Reputation: 437 Joined: 01/26/16 Last Seen: Wednesday at 03:00 PM Share Posted May 6, 2017 Another cheap alternative for larger servers: Google Cloud Storage Nearline I used to back up my files to this when I was doing stuffs in the Minecraft scene. Quote Link to comment Share on other sites More sharing options...
Hnomkeng Posted June 21, 2017 Group: Members Topic Count: 29 Topics Per Day: 0.01 Content Count: 99 Reputation: 2 Joined: 02/23/14 Last Seen: 5 hours ago Share Posted June 21, 2017 On 5/5/2017 at 8:28 PM, Habilis said: It is a custom backup solution I've been working on, Thanks to feedback of community, I managed to make a V2 V2 of my Database Backup solution Featuring 1. generate a backup of databases specified in a list 2. Name them with yyy-mm-dd[DatabaseName] format 3. Compress them into .7z using maximum compression 4. Set a password on .7z archive 5. Send them to cloud storage Google Drive 6. Write logs 7. Removes all compressed backups 28 days or older (keeping local folder nice and clean) 8. Can be automated with cron to run even every 12 hours Ow yeah, Don't worry about someone hacking your GoogleDrive, if you put 14 character+ Alphanumeric password on yout backup archives it is going to be bruted loong time... How to setup on CentOS. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.