/etc/rc.d/init.d/mysqld restart

M

Mdave

Verified User
Joined
Jan 17, 2006
Messages
5
Hi ,
Can this in cronjobs..?
*/30 * * * * /etc/rc.d/init.d/mysqld restart
I try it , but no result

Then try this
*/30 * * * * /usr/local/mysql/bin/mysql -u root -p MYPAS <$HOME/mysql_flush_query_cache.sql > flush.log 2>&1
No result.

Somebody help.?
or a script to auto flush host.

The Point is we have a aplication on one server, but the script is on our second server, and every 2 houres, we get a flush host message.

Momently we do a mysql restart ( ssh or via DA )

But we have a nice cronjob , of file to do this.

File locate on /etc/rc.d/init.d/mysqld

Thx
 
NO , sorry , but this give 0 result.
Thx for try.

Anyone else.?
 
When you say no result, what exactly do you mean? Is there any output being mailed back to you? Do you see some cron errors in your log files? When you said "The Point is we have a aplication on one server, but the script is on our second server" does that mean you are trying the call the script which resides on another server (via NFS or something)?
 
No result, i mean that this is not working.

Crons logs for it aren't empty
Server one
get te data, and on server 2 is the sql base ( script on server one is a inserto >> server 2)

Question is how do i make a automatic flush host or msqld restart via cronjobs :s
 
If the cron logs aren't empty, what do they say?

I don't see why
*/30 * * * * /etc/rc.d/init.d/mysqld restart
wouldn't work, but without knowing what your log files say, I can't really tell you.
 
If mysql is busy and there are a lot of daemon processes running, mysql may never finish stopping. It could time out.

Jeff
 
You must log in or register to reply here.
Back
Top