Re: 2 questions: hostname variable and exit if slave

2004-10-06 Thread Ted Byrne
Regarding number 1, you might be able to do something with this: mysql> show variables like 'pid%'; +---+-+ | Variable_name | Value | +---+--

2 questions: hostname variable and exit if slave

2004-10-06 Thread Brian C. Hill
I have 2 unrelated questions: 1) Is there any way to get the hostname that the server is running on from within mysql? All I can come up with is (pseudo coded): mysql> system echo insert mysql.hostname `hostname` ... > hostname.sql mysql> s