Backups .... Dull nerdy stuff

What can the Admins do to help, any requests for changes, updates, etc.
User avatar
weeksy
Site Admin
Posts: 23421
Joined: Sat Mar 14, 2020 12:08 pm
Has thanked: 5451 times
Been thanked: 13087 times

Backups .... Dull nerdy stuff

Post by weeksy »

So i'm wondering what to do here...

In as simple terms as possible i've used phpMyAdmin to create a backup of all the Database and Schema. I've also used the BAckup facility within the host and lastly i've FTP'd the source files for the forum onto another location.

I may need some help if it ever goes pear shaped, but it should be entirely possible to recover from any sort of failure now.

However my next question is, what to do if i drop dead tomorrow and it goes down.

So i'm thinking we need some sort of off-site and off-weeksy backup and a dedicate member who has techie skills and should be able to get this thing up again with the files and some passwords.... Or even using their own host, they'd still have the files etc.

Now, currenltly we've only got 150 members and i don't know the skills of all of you that well, but i have someone in mind for this but would like to throw it out for a disucssion.

Are we comfortable giving another one of the members what is essentially full access to everything ? I mean, we trust me, so no reason not to trust them equally ?
Are we happy to potentially use some of the funds for an off-site FTP area ? The files are currently stored off-site now, but not on a location i could give anyone else access to :)

Or do we simply accept, if i drop dead, then it's tough titty.

Any thoughts appreciated.
cheb
Posts: 4905
Joined: Tue Mar 17, 2020 6:51 am
Been thanked: 2617 times

Re: Backups .... Dull nerdy stuff

Post by cheb »

What's here to be trusted with? Bare financial details, if that, an email address and a password.

If I trust you with that then I trust someone you nominate.
User avatar
weeksy
Site Admin
Posts: 23421
Joined: Sat Mar 14, 2020 12:08 pm
Has thanked: 5451 times
Been thanked: 13087 times

Re: Backups .... Dull nerdy stuff

Post by weeksy »

cheb wrote: Fri Mar 20, 2020 8:10 am What's here to be trusted with? Bare financial details, if that, an email address and a password.

If I trust you with that then I trust someone you nominate.
There's no financial details passed through or about on here.. There's no passwords either... Just email addresses
cheb
Posts: 4905
Joined: Tue Mar 17, 2020 6:51 am
Been thanked: 2617 times

Re: Backups .... Dull nerdy stuff

Post by cheb »

Even less to worry about then.
User avatar
Yorick
Posts: 16738
Joined: Sat Mar 14, 2020 8:20 pm
Location: Paradise
Has thanked: 10265 times
Been thanked: 6886 times

Re: Backups .... Dull nerdy stuff

Post by Yorick »

Five years ago I'd have been on this like Gremlin on free pizza and beer.

But a bit out of practice now.
User avatar
weeksy
Site Admin
Posts: 23421
Joined: Sat Mar 14, 2020 12:08 pm
Has thanked: 5451 times
Been thanked: 13087 times

Re: Backups .... Dull nerdy stuff

Post by weeksy »

Yorick wrote: Fri Mar 20, 2020 1:08 pm Five years ago I'd have been on this like Gremlin on free pizza and beer.

But a bit out of practice now.
TBH fella, whilst it's been a bit tricky at times, it's a long way from complicated, once you know how they do things, it's just a question mostly of dragging and dropping folders into the right places. Like anything in IT, it's a question of doing it EXACTLY how it wants to be, but sometimes it's not exactly clear as to where/why/how. So you end up wandering round in the dark a little bit until you realise it didn't want it in THAT folder, but it wanted another folder creating and then it putting in THAT folder.
Basically the code points in the CFG file to a specific folder, if you put it anywhere else, it's not happening. Sometimes the Zip files extract with the correct syntax, sometimes not.
User avatar
weeksy
Site Admin
Posts: 23421
Joined: Sat Mar 14, 2020 12:08 pm
Has thanked: 5451 times
Been thanked: 13087 times

Re: Backups .... Dull nerdy stuff

Post by weeksy »

So today i sorted an FTP (Filer Transfer Protocol) installer and have installed and FTP'd (copied) off all the website to a secure off-site location.

We now have
FTP of files
MySQL backup
'full backup' using the hosting software.

So unless i've missed something glaringly obvious, we should have the ability to recover should something catastophic happen.