How to skip reading /etc/my.cnf by mysqld

2006-10-07 Thread dvd 
Hi:

I am trying to test mysql options and would like to
have mysqld only read ~/.my.cnf instead of using the
normal sequence to read /etc/my.cnf $datadir/my.cnf and ~/.my.cnf.
This would prevent many unexpected issues in testing.
But I could not find the way to disable the /etc/my.cnf.

Any help would be appreciated.

Thanks

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

Re: How to skip reading /etc/my.cnf by mysqld

2006-10-07 Thread Visolve DB Team 
Hi,

Try,

  libexec/mysqld --verbose --help
for mysqld options with variables

or

 bin/mysqld_safe --verbose --help
for mysqld options

For instance I want only /etc/my.cnf read and skip reading of other default 
file, 

./bin/mysqld_safe --defaults-file=/etc/my.cnf

Hope this will do good.

Thanks 
ViSolve DB Team.

- Original Message - 
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, October 07, 2006 11:41 AM
Subject: How to skip reading /etc/my.cnf by mysqld


 Hi:
 
 I am trying to test mysql options and would like to
 have mysqld only read ~/.my.cnf instead of using the
 normal sequence to read /etc/my.cnf $datadir/my.cnf and ~/.my.cnf.
 This would prevent many unexpected issues in testing.
 But I could not find the way to disable the /etc/my.cnf.
 
 Any help would be appreciated.
 
 Thanks
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]