Re: MySQL autorestart when crash or stop

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 11:17:51 -0600

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@friend.fr> wrote in message
news:fff259ae.0412220913.2f05ce74@posting.google.com...
> 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

Relevant Pages

  • Re: Does apache stop a script mid execution ?
    ... If the user calls a time consuming script and then stops or refreshes ... How does it relate to e.g. a script performing a large mysql query? ... 2.b) how the connection is set up. ... the server stops the script execution. ...
    (comp.lang.php)
  • Re: Does apache stop a script mid execution ?
    ... If the user calls a time consuming script and then stops or refreshes ... the way the client is implemented in the php mysql extension and 2.b) how the connection is set up. ... the server stops the script execution. ...
    (comp.lang.php)
  • Re: Cyrus IMAP with pam_mysql?
    ... FreeBSD, but if you check the startup script, all the parameters are ... Default log directories are in the default data directory, ... Makefile for mysql) They are changed in the above script prior to ... imaps auth sufficient pam_unix.so ...
    (freebsd-questions)
  • Re: MySQL to SQL
    ... basically I want to take a MySql script and load it into a SQL database. ... BIOS_RELEASE_DATE datetime default NULL, ... CUSTOM_TEXT_FIELD1 mediumtext, ...
    (microsoft.public.scripting.wsh)
  • Re: mysql - kern.maxfiles limit exceeded by uid 500 please see tuning(7)
    ... Since mysql crashes after 5 days of running your script, ... better check its operation and see if it is causing your system to exceed ...
    (comp.unix.bsd.freebsd.misc)