Code snippet to run at database service startup

2006-08-07 Thread Asif Lodhi

Hi,

What if I want certain variables initialized and certain code to run
at the database service startup?  I am running 5.0.22 on Windows XP
Service Pack 2.  Are there any tirggers that can tell me that the
database is starting up?

--
Thanks in advance,

Asif

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Code snippet to run at database service startup

2006-08-07 Thread Daniel da Veiga

On 8/7/06, Asif Lodhi [EMAIL PROTECTED] wrote:

Hi,

What if I want certain variables initialized and certain code to run
at the database service startup?  I am running 5.0.22 on Windows XP
Service Pack 2.  Are there any tirggers that can tell me that the
database is starting up?



You can write a simple application to monitor the error log file for
changes and check it to see if mysql was shutdown and/or started.
Accourding to the manual:

The error log file contains information indicating when mysqld was
started and stopped snip

--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]