ElkArte Community

General => Chit Chat => Topic started by: radu81 on March 15, 2015, 03:29:12 pm

Title: Backup, what do you use?
Post by: radu81 on March 15, 2015, 03:29:12 pm
Just curious to know what kind of solution do you guys use to make regular backups of your forum (database and files)
Title: Re: Backup, what do you use?
Post by: emanuele on March 15, 2015, 04:10:17 pm
It's a long time I don't do a backup...

/me runs

Usually I use phpmyadmin (also because I have few scripts to backup) and ftp.
Title: Re: Backup, what do you use?
Post by: Spuds on March 15, 2015, 04:19:42 pm
I use amazon s3 storage.

I have a cron job runs on the sites, saves everyday for the past two weeks (14 backups), every saturday for the past 2 months (8 or 9 backups), first day of the month going back forever if you want.  This does both a backup of my database and site files.

Pretty much this script  https://github.com/ianneub/php_backup_s3 with some tweaks I needed.

Costs about $1.60 (with tax) a month with my usage which is ~50G a month.  Could also use Glacier storage which is even less expensive, just has a delay in getting the data back (where as s3 you can select a recovery point and get the file)
Title: Re: Backup, what do you use?
Post by: radu81 on March 15, 2015, 04:48:12 pm
Quote from: emanuele – It's a long time I don't do a backup...
that's not a good idea ;)
Quote from: emanuele – Usually I use phpmyadmin (also because I have few scripts to backup) and ftp.
yep, I also use that, but now my forums are growing up and phpmyadmin cannot export big database.

I'm still on shared hosting, I prefer a shared because I don't have the knowledge to manage a VPS. A managed vps in Italy is not so cheap. My hosting is offering a daily backup, so only the "backup of yesterday" is availble. I should find some alernatives.

On joomla I use Akeeba Backup since years and does a good job. All their products works out of the box. I think I will try the Akeeba solo version. I have a Box.net account with 50GB that I don't use, so I think it would be cheaper for me
https://www.akeebabackup.com/documentation/akeeba-solo.html

p.s. interesting the solution spuds posted ;)
Title: Re: Backup, what do you use?
Post by: Spuds on March 15, 2015, 05:27:16 pm
QuoteA managed vps in Italy is not so cheap
Just stop buying your wife iPhones and you should have plenty of money left over :P :P
Title: Re: Backup, what do you use?
Post by: radu81 on March 15, 2015, 05:53:59 pm
lool, I'm not a fan of iphones and all the iWorld :D She bought that phone, not me :D Her friend told her it's the best phone :) Lool
I always had nexus phones: nexus 3, galaxy nexus, nexus5 and Nexus7 tablet

when my shared hosting will not handdle all the traffic I have I will switch to a managed vps. I just noticed my shared also offers SSH support, now I try to backup using putty
Title: Re: Backup, what do you use?
Post by: Jorin on March 16, 2015, 02:31:19 am
Quote from: emanuele – It's a long time I don't do a backup...

/me runs

Similar to me.  :-[
Title: Re: Backup, what do you use?
Post by: emanuele on June 02, 2015, 05:38:11 pm
I'm testing what may look like a cheap solution. LOL

I'm trying to use google drive for the backups, I found a couple of solutions that allow to manipulate (to a certain extent) files from the CLI (and so from cron jobs) on linux:
http://www.webupd8.org/2014/09/gdrive-simple-google-drive-cli-client.html
http://www.webupd8.org/2013/09/mount-google-drive-in-linux-with-google.html
I'm using the first at the moment.
And to delete the old backups I'm testing out google-apps-script:
https://developers.google.com/apps-script/
When everything is properly in place I'll push somewhere the relevant code if anyone is interested. :D
Title: SPLIT: Re: Backup, what do you use?
Post by: emanuele on November 25, 2015, 12:35:58 pm
I moved the posts related to the other discussion... to the other discussion. :P