homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

mysql cron job

5+ Year Member

Msg#: 4029911 posted 7:59 am on Nov 23, 2009 (gmt 0)

I would like mysql server perfom backups every day at noon.

How do I configure that offline on my computer? Is that possible for a hosted database too (for my hosted website)
kind regards



WebmasterWorld Senior Member whoisgregg us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 4029911 posted 6:50 pm on Nov 23, 2009 (gmt 0)

As far as I know, MySQL doesn't have built-in cron jobs. If you are on a *nix type system, look into the "crontab" program to schedule tasks.

For web hosting, you have to check with them to see if they support that. Most hosting control panels have a section just for cron jobs and it's pretty easy to configure them (once you know what command you want to run).


Msg#: 4029911 posted 9:52 am on Dec 2, 2009 (gmt 0)

I would like to know how to do this aswell, i would like a dump of the database to be emailed to be once per day. Any ideas?


5+ Year Member

Msg#: 4029911 posted 12:02 pm on Dec 5, 2009 (gmt 0)

I am on windows NT and i run mysql 5.1.33. I really dont know how to see if there is that cron job option. By the way, assuming the cron job on my windows machine is possible, can that cron job be executed when i am off my work and the computer turned off?


Msg#: 4029911 posted 8:53 pm on Dec 15, 2009 (gmt 0)

There are other options, folks.

There's a number of online cron replacement services out there. If you're on free web hosting and don't have access to cron, or are on a local machine but don't want to leave it on all the time, this is a GREAT option.

[edited by: tedster at 9:56 pm (utc) on Dec. 15, 2009]

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved