[ubuntu-uk] Shutdown mysql with cron

Alan Lord (News) alanslists at gmail.com
Wed Aug 11 10:55:19 BST 2010


On 11/08/10 00:13, Paul Willis wrote:
> Hi
>
> I'm trying to shutdown MySQL on an Ubuntu 10.04 server for half hour everyday using cron but I can't get it to work

Not sure why you want to, but hey ho. (IIRC I've created a "backup" user 
before and just given it lock_tables privilege to all databases).

crom has a *very* restricted path by default (/bin,/usr/bin) IIRC, you 
might need to add a PATH="..." line to your crontab.

Another other commenter suggested logging the output. This is a good 
idea too.

Al


-- 
The Open Learning Centre
http://www.theopenlearningcentre.com




More information about the ubuntu-uk mailing list