mysql cron

[rldev]

Can someone post a cron entry to properly stop and start mysql say once a day?

 

[vandal]

on redhat systems simply:

0 * * * * /sbin/service mysql restart

would restart it every hour.

 

[rldev]

strange their is no restart on my RHE system. Just start and stop.

 

[vandal]

that is odd, you should have restart. what does "service mysql" from root output?

 

[rldev]

unrecognized service.

 

[vandal]

service mysqld ?

 

[rldev]

yes

/etc/init.d/service mysqld

but this doesn't work from cron:

/etc/init.d/service: No such file or directory

How do I execute the command?

I have:

0 */12 * * * /etc/init.d/service mysqld restart

 

[Mik3yZ]

why the slash in front of 12?

0 * 12 * * * service mysqld restart

or

0 * 12 * * * /etc/init.d/service mysqld restart

 

[rldev]

I want to run it every 12 hours. The cron kicks back the following email when running:

/bin/sh: service: command not found

What's the problem?

 

[rldev]

anyone?

 

[selfwebhosting]

In my case it is...

/sbin/service mysqld restart

I am using Fedora 4 OS.