Help! - Cron Examples And How-to

[djgizmo]

Ok, I searched the forums and could not seem to find what I am looking for so I'm posting this.

 

I'll just list what I need...

 

Cron #1

I need a someone to tell me how to make a cron file that can..

 

Backup my public html folder and all its sub-folders

Backup a specific mysql database

 

zip the html folder in its own file

output the mysql to a text sql file

then zip both of those files together

 

Needs to be done everynight @ a 0100 and needs to overwrite the same file everynight

 

----------------------------------------

Cron #2,

Needs all of the above, but needs to be ftp'd to an external source once a week.

 

------------------------------

 

Also, I need someone to inform me how to excute these crons in the cron tool in the cpanel. Sorry if this might be a double post from someone else.

 

Sean

[MikeJ]

Not exactly what you are looking for, but the easiest method is to let cPanel do the work for you. You can use something like the script I wrote to cron the cpanel backup that will FTP the entire account backup to a remote server every time it's run.

 

Otherwise, you are basically asking for some rather specific scripts to be written for you.