How would i go about setting up daily backups of my site

How would i go about downloading daily backups of my sites Databases, and then say a monthly backup of its Raw files to my Hard drive on a cron job (automatically)

I have Shell access (don't know how to use it) if that helps.

thanks again

 

Create a shell script with the proper commands and run it from cron. You will have to stop the sql if you want the raw files tho.

 

aaw well i don't know anything about shell, is there any programs out there?

 

If you are on cpanel, you could use this:

http://www.tech-pro.net/site-backup-cp.html

It works good. I bought a license but dont use it anymore as I have dedicated remote backup now.

 

Just google if you can't make your own there is plenty of flavors some send to your email some stay on-site some auto increment etc.
A quick search got this http://webmasters-forums.com/i-want-sql-backup-script-t-991.html but like i said there's plenty out there.

 

If you are willing to learn a bit of shell you could create a script that would do some simple backups...

#!/bin/bash
cd /web/root/dir
tar -cvf web.tar .

Code (markup):

If you type the above in a file, you may need to "chmod +x filename" so that you can run it. You'll need to type in the right directory though.

This would create a file in some top level directory that contained all the material under that directory. You could download and save this file from time to time using your browser (and so could anyone else if it was publicly available).

If your material is not sensitive and you have turned off directory indexes it may be worth considering.

Similarly, you could build a script that ran mysqldump to get at your table contents. These could also be run by cron job and download by yourself whenever you decided to do it.

You'll need to spend some time in the shell futzing around with things while you have the manuals open...