[ubuntu-us-mi] How to shut down MySQL on Ubuntu Lucid 10.04?

[Robert Citek]

On Thu, Dec 16, 2010 at 1:03 PM, mike <mcruz32 at wowway.com> wrote:
> Maybe this can help.
> http://upstart.ubuntu.com/faq.html#reload

Thanks, except that is also fraught with issues.

"If a job is running, the changes to the definition will not occur
until the job has been stopped;"

And I can't stop the job (mysql in this case) because upstart will
cause the tables to get corrupted by killing mysqld too soon.

"To force a reload you may send init the HUP signal, or use the
following command:  initctl reload "

Unfortunately, that reload doesn't work for me:

$ sudo initctl reload
initctl: missing job name
Try `initctl --help' for more information.

If I specify mysql as the job, that seems to be equivalent to
/etc/init.d/mysql reload.  The man page for initctl seems to confirm
this:

       reload JOB [KEY=VALUE]...

              Sends the SIGHUP signal to running process of the named
JOB instance.

So a reload sends SIGHUP to the JOB and not to init.

The one thing I have not tried is 'kill -SIGHUP 1".  I'm going to
setup a VM before I try that one on our servers.

Regards,
- Robert