View Single Post

   
  #2 (permalink)  
Old 04-24-2008, 06:09 PM
Gordon Burditt
 
Posts: n/a
Default Re: 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.


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.

Reply With Quote