Cron Jobs

  • Nucleo
  • SausagePorkPie
  • Mastermind
  • User avatar
  • Posts: 2297
  • Loc: UK - England

Post 3+ Months Ago

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.
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9072
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

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.
  • Nucleo
  • SausagePorkPie
  • Mastermind
  • User avatar
  • Posts: 2297
  • Loc: UK - England

Post 3+ Months Ago

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
  • mrdance
  • Born
  • Born
  • mrdance
  • Posts: 2

Post 3+ Months Ago

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

http://www.visualcron.com
  • rDolay
  • Expert
  • Expert
  • rDolay
  • Posts: 541

Post 3+ Months Ago

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 :D
  • madmonk
  • Mastermind
  • Mastermind
  • madmonk
  • Posts: 2115
  • Loc: australia

Post 3+ Months Ago

great links guys.!
  • r0Gu3
  • Newbie
  • Newbie
  • r0Gu3
  • Posts: 5
  • Loc: . : T-Dot : .

Post 3+ Months Ago

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 :P

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....

Post Information

  • Total Posts in this topic: 7 posts
  • Users browsing this forum: No registered users and 6 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.