MySQL autorestart when crash or stop

#1

Hi,

Trying to restart MySQL when it is down from a crontab event.

Placed the following script kindly provided by a Gentleman in a file :

checksql --->

#!/bin/sh
/etc/rc.d/init.d/mysqld status >/dev/null 2>&1
if [ $? -ne 0 ]; then /etc/rc.d/init.d/mysqld restart >/dev/null 2>&1;
fi

And a crontab event */each several minutes that execute the script.

Problem : the script is not functioning.

+ :
- /etc/rc.d/init.d/mysqld status > return "stopped" or "started"
- Crontab event as configured launch correctly scripts (tested on a
send mail script)
- /etc/init.d/mysqld status or /etc/rc.d/mysqld status does not work.

I thank you for your advises.

Kind Regards

#2

This is a Microsoft SQL Server newsgroup. If I knew MySQL I would try to
help, but I don't, so I can't.

--
Keith

"Solange Ezveff" <se (AT) friend (DOT) fr> wrote

Quote:

Hi,

Trying to restart MySQL when it is down from a crontab event.

Placed the following script kindly provided by a Gentleman in a file :

checksql ---

#!/bin/sh
/etc/rc.d/init.d/mysqld status >/dev/null 2>&1
if [ $? -ne 0 ]; then /etc/rc.d/init.d/mysqld restart >/dev/null 2>&1;
fi

And a crontab event */each several minutes that execute the script.

Problem : the script is not functioning.

+ :
- /etc/rc.d/init.d/mysqld status > return "stopped" or "started"
- Crontab event as configured launch correctly scripts (tested on a
send mail script)
- /etc/init.d/mysqld status or /etc/rc.d/mysqld status does not work.

I thank you for your advises.

Kind Regards

#3

Sorry, but this is a Microsoft SQL Server newsgroup.

AMB

"Solange Ezveff" wrote:

Quote:

Hi,

Trying to restart MySQL when it is down from a crontab event.

Placed the following script kindly provided by a Gentleman in a file :

checksql ---

#!/bin/sh
/etc/rc.d/init.d/mysqld status >/dev/null 2>&1
if [ $? -ne 0 ]; then /etc/rc.d/init.d/mysqld restart >/dev/null 2>&1;
fi

And a crontab event */each several minutes that execute the script.

Problem : the script is not functioning.

+ :
- /etc/rc.d/init.d/mysqld status > return "stopped" or "started"
- Crontab event as configured launch correctly scripts (tested on a
send mail script)
- /etc/init.d/mysqld status or /etc/rc.d/mysqld status does not work.

I thank you for your advises.

Kind Regards

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MySQL autorestart when crash or stop

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming

MySQL autorestart when crash or stop - 12-22-2004 , 11:13 AM

Re: MySQL autorestart when crash or stop - 12-22-2004 , 11:17 AM

RE: MySQL autorestart when crash or stop - 12-22-2004 , 11:21 AM