I have found a utility
MySQLDumper and would love to execute it weekly to back up my database(s). I know how to integrate a link into AdminPack but have not a clue about cron jobs etc., which I will surely need to achieve this. Can anyone point me to a good tutorial which doesn't assume that readers have a Bsc in Computer Science?
A "cron job" is a job that runs on a set schedule under *NIX OSes. On web hosts with a Control Panel, you can set one up to run there. If you don't have that, you can SSH into the box and set up a cron job there on many hosts. Windows has Task Scheduler, which effectively does the same thing as cron. If you don't have a cron-like interface available at all, then you'll need something that can emulate it (see below).
The bigger question is where to store your backup? Scheduling the database dump to run is one thing, but getting the data off the server to another location is important as well. They are usually two separate tasks. Plus, you have to be careful to make sure the database can't be downloaded via a regular web browser.
I built this a while ago:
http://barebonescms.com/documentation/we...te_backup/
However, I can't really recommend it yet since there isn't a restore module, but it is quite flexible.
As to a tutorial, well, each backup system is different, which is why there aren't a whole lot of tutorials on the topic.
As usual the documentation looks very comprehensive! I shall study and report back...