Wanted - Cron-Job SQL/PHP Server guru |
Wanted - Cron-Job SQL/PHP Server guru |
Nov 7 2008, 02:00 PM
Post
#1
|
|
Founder Group: Chairman Posts: 14432 Joined: 8-February 04 Member No.: 1 |
Amoungst our troops there must be someone who knows how to write Cron-jobs.
I'd like to set up the UMSF server to automate backups of the forum DB and attachments folder, but it's just a bit beyond me. It's a LAMP setup using Cpanel 11. Anyone who has 'the knowledge' to help me out - let me know! No pay, but you can have an UMSF subdomain to put stuff on ( like Mike has for MMB anims ) as a UMSF perk Cheers Doug |
|
|
Nov 7 2008, 09:40 PM
Post
#2
|
|
Member Group: Members Posts: 646 Joined: 23-December 05 From: Forest of Dean Member No.: 617 |
Wow, there's not much I can add to Fran's comment. Tchah!, and I had geekpr0n.unmannedspaceflight.com all worked out in my mind's eye...
If you want to get fancy / clever in future, you could try using rsync to do incremental (only save the changes) remote network backups with ssh crypto. A simple incantation is a one-liner: CODE rsync -a -k -v -e ssh /home/andrew/* andrew@sluggbox:/media/sdb1/home/backup/thinkpad/ It's less typing than the shell script approach, but you have to be able to install rsync if it's not there already, and set up the remote machine, and be able to handle the bandwidth costs if you're doing this over the Internet rather than to the next machine down in the rack. The advantages of having the backups offsite is that you can easily be back up and running if the data centre / hosting location is offline for an extended period. There are surprisingly many unexpected scenarios [1] that can cause you to lose connectivity to the site, apart from the apocalyptic stuff the DR geeks get exercised about. Also the traffic on the wire is encrypted.[2] I hacked up something along these lines when my techno-paranoid father finally bought a digital camera, and started accumulating irreplaceable data which he stored on a single HD, in a cheap Dell box, situated in a single-glazed, ground-floor room, in a completely un-alarmed house, in front of a window next to a public footpath. Oh yeah, and the window doesn't have a lock. [3] There are also a couple of projects that use rsync as the core of a more full-featured network backups setup. A friend swears by Bacula, though I've not tried it myself. Lots of other recipes along the same lines are out there. [1] *cough* Gloucester floods 2007 fasthosts [2] One of the dirty little secrets of infosec is that examples of unencrypted traffic being maliciously intercepted are pretty rare these days. Unless, that is, the victims are too embarrassed to call the cops -- or don't realise it's happening... [3] Oh yes, and it's also an absolute tinderbox of 18th century untreated wood, protected only by haphazardly concealed battery-operated smoke alarms which I hide around the place whenever I'm there, but which they throw out when the battery goes flat and they start beeping. If you need to give a sparkie sleepless nights, ask me for a pic of the fuseboard... </tangent>) -------------------- --
Viva software libre! |
|
|
Lo-Fi Version | Time is now: 11th May 2024 - 09:22 AM |
RULES AND GUIDELINES Please read the Forum Rules and Guidelines before posting. IMAGE COPYRIGHT |
OPINIONS AND MODERATION Opinions expressed on UnmannedSpaceflight.com are those of the individual posters and do not necessarily reflect the opinions of UnmannedSpaceflight.com or The Planetary Society. The all-volunteer UnmannedSpaceflight.com moderation team is wholly independent of The Planetary Society. The Planetary Society has no influence over decisions made by the UnmannedSpaceflight.com moderators. |
SUPPORT THE FORUM Unmannedspaceflight.com is funded by the Planetary Society. Please consider supporting our work and many other projects by donating to the Society or becoming a member. |