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

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 |