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