In the Apache world, you might be familiar with tweaking your config file(s) and then running
$ apachectl configtest
to see if the config parses. We've been discussing this on the drizzle mailing list and talking in general about configuration handling and management. Well, it turns out that you can fake it in MySQL and Drizzle too.
If you have a new configuration in /tmp/new.cnf, try this:
$ mysqld --defaults-file=/tmp/new.cnf --verbose --help
And it'll run mysqld (or drizzled), parse the config, report any problems, print help, and exit without initializing storage engines or trying to grab a port.
Thanks to Baron Schwartz, Arjen Lentz, and Sheeri Cabral (book) for helping to demonstrate this.
Posted by jzawodn at April 29, 2009 07:45 AM
The opinions expressed here are mine and
mine alone. My current
, or previous
employers are not responsible for what I
write here, the comments left by others, or the photos I may share. If
you have questions, please contact
. Also, I am not a journalist or reporter. Don't "pitch" me.
I do not share or publish the email addresses
or IP addresses of anyone posting a comment here without consent.
However, I do reserve the right to remove comments that are spammy,
off-topic, or otherwise unsuitable based on my comment
. In a few cases, I may leave spammy comments but remove any
URLs they contain.