add configtest option to mysql rc script

[Gena01]

Is it possible to add "configtest" option to rc script to validate the configuration file without having to restart mysqld.

I've seen similar functionality in some rc scripts (apache comes to mind).

[Gena01 (gena01)]

Related blog entry: http://www.mysqlperformanceblog.com/2008/02/12/how-to-check-mysql-config-files/

[Cafuego (cafuego)]

apache does this by calling a distributed binary - apachectl - which parses the config file.

There is not currently such a utility for mysql and as far as I can tell there is no parameter for the server binary to simply parse the my.cnf file and then exit.

[Cafuego (cafuego)]

Ok, my desktop mysqld was too old. I've started work on the shipped init script and the debian/ubuntu one.

[Arjen Lentz (arjen-lentz)]

On 19/12/2008, at 10:26 AM, Cafuego wrote:
> apache does this by calling a distributed binary - apachectl - which
> parses the config file.
>
> There is not currently such a utility for mysql and as far as I can
> tell
> there is no parameter for the server binary to simply parse the my.cnf
> file and then exit.

mysqld --help --verbose
generally barfs appropriately when it can't parse the my.cnf

But since usually mysqld_safe starts it, it's not quite identical to a
normal startup.

> --
> add configtest option to mysql rc script
> https://bugs.launchpad.net/bugs/309251
> You received this bug notification because you are a member of
> OurDelta-
> developers, which is the registrant for OurDelta.
>
> Status in OurDelta - Builds for MySQL: New
>
> Bug description:
> Is it possible to add "configtest" option to rc script to validate
> the configuration file without having to restart mysqld.
>
> I've seen similar functionality in some rc scripts (apache comes to
> mind).

--
Arjen Lentz, Director @ Open Query (http://openquery.com.au)
MySQL Training from $475/day, DBA/Support from $249/month

My blog is at http://arjen-lentz.livejournal.com
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org

[Cafuego (cafuego)]

It would be good if someone could try the fix on an RPM based distro; grab at least r47 of the ~cafuego/ourdelta/ourdelta-configtest

'invoke-rc.d mysql configtest' works fine on my Ubuntu box now, but that doesn't use the shipped initscript.