Can you recommend a script which would backup the mysql database, and a folder .
Optimally, want the script to backup the database & a folder multiple times during a 24-hr period on the webserver in a compressed format to save space, & tar/combine the backups and transfer it to local PC(XP) at least once before the backups are deleted and new ones are created on the webserver. It would be helpful to have the date/time listed on the filename for the backup.
Webserver has Cpanel, Linux (Reseller/Hostingzoom account).
phpMyAdmin has ability to dump whole database with it's structure and data by comressing it to .gzip extension, so using that part of phpMyAdmin code and writing another little one, you can create php script, put it into cron jobs. Script could archive these backups in some temporary folder, send to client (that's you) mail box and delete temporary backup files.