I was wondering if anyone help me with a MySQL Query. Here is what I am planning for:

• On our site, I am wanting to install few couple of demo scripts, and each script will have its own mysql dump
• Every Hour, I want the cron job to restore mysql dump from a designated location, so in a way it will overwrite any edits, that end users might have done while playing with the demo.

Does anyone knows on how do I setup such cron job?

Also, is there a way to backup MySQL db, using a cron?

Thank you.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Hi,

Something like this should work:


..and in crontab format, something like this:


Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Thanks a lot Andy, I very much appreciate it.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------