tool to check the validity of my.cnf file

just wondering if there is any such tool to check the validate and
sanify the my.cnf file for mysqld.. I have made n number of updates to
my.cnf and I want to check before restarting the mysql and further fall
into troubles.

Nikhil

>just wondering if there is any such tool to check the validate and
>sanify the my.cnf file for mysqld.. I have made n number of updates to
>my.cnf and I want to check before restarting the mysql and further fall
>into troubles.

mysqld --help seems to do this fairly well. If I put in an invalid
option (spelled wrong, for instance) in /etc/my.cnf, I get an error
message about it.

It may not check consistency of options, or that all the cache
options specified require memory that the server can actually get
when it starts up. It does seem good for syntax errors and funny
stuff in values.

Gordon Burditt wrote:
>> just wondering if there is any such tool to check the validate and
>> sanify the my.cnf file for mysqld.. I have made n number of updates to
>> my.cnf and I want to check before restarting the mysql and further fall
>> into troubles.
>
> mysqld --help seems to do this fairly well. If I put in an invalid
> option (spelled wrong, for instance) in /etc/my.cnf, I get an error
> message about it.
>
> It may not check consistency of options, or that all the cache
> options specified require memory that the server can actually get
> when it starts up. It does seem good for syntax errors and funny
> stuff in values.
>
Thanks Gordon, it is interesting to know.

[Actually I was expecting some sort of what apachectl with configtest
does for apache or xmllint or morever svccfg validate for SMF in Solaris. ]

Cheers,
Nikhil