Cron Jobs

Hi all

( i put this in the hosting forum because it is something to do with cpanel, but if you think it is more coding or design, feel free to move it)

I know what Cron jobs are capable of. like remotly backing up data and so forth.

what i want to know is can i set it to send a backup of 1 mysql database to email?

if so, whats the command?

i would like it to do this everyday, but i am unsure on how to do it.

All a cron job does is intialize a program or command at any particular time or time intervals throughout the day. By itself cron jobs cannot do anything. They are only used to automatically startup programs throughout the day.

So you could use a program or command that would do what you want and set it up in a cron job (crontab) so that it performs that task once a day for example.

ok, right...

i will look into this more then, thanks

i just saw on another forum that using cron jobs they were able to send backups of their site to different webspace, say everyday.

thanks bwm

If you want to run cron on windows you can look at this alternative:

http://www.visualcron.com

It is littlebit complex to tell with some sentences but yes it would be done

Just fallow the steps http://www.classicwebdesign.com/db_backup/ and dont thank me

great links guys.!

the link that dolay shared with us is what i used ... and i've set it up to send me a backup of my DB every hr thru e-mail ...

i get the mails all well and good ... but as a test i went and uploaded the backup mysql db (thru cpanel -> backups -> restore database...) and usualy when one uploads a db in this manner u get a page of results of what was added and what not .... but rather i get an empty page

so my question is ... based on the link that dolay shared, the backups that are generated ... are they cpanel restore compatible? ... i recall reading at the end of the tutorial on taht site taht comments in the db are shown as "--" rather than "##" and was wondering if thats the reason why the backed up db's have no content whatsoever....