port load and unload commands with respect to MySql

[Chris Janton]

On 2010-03-05 , at 01:34 , Scott Haneda wrote:
> 
> I have read this over twice now:
>    http://dev.mysql.com/doc/refman/5.1/en/server-shutdown.html
> and I believe _maybe_ that is saying that `port unload` will in fact be a safe way to shut down, but it is not 100% clear to me either.

Using the following references

 http://dev.mysql.com/doc/refman/5.1/en/server-shutdown.html
 http://developer.apple.com/mac/library/DOCUMENTATION/MacOSX/Conceptual/BPSystemStartup/Articles/BootProcess.html
 daemondo --help
 launchctl man page
 kill man page

All of these should result in essentially the same actions by MySQL with regard to "proper" shutdown

	shutdown command (kills all the daemons)
	launchctl unload (stops the job if running - can you say ''kill'') 
	kill ''daemondo pid'' # mysql5 daemondo
	kill ''mysqld_safe pid''
	kill ''libexec/mysqld pid''

When I do an upgrade to mysql I usually just do

	sudo kill -TERM daemondo_pid

and give things a moment or two to get back to normal. The daemondo process gets restarted, new version of software should be running.

If you want mysql to "stop" and not start backup up for a while

	sudo port unload mysql5

which can get restarted when you are ready

	sudo port load mysql5

Simple answer is - shouldn't matter how you stop mysql.


8)
----------------------------------
Chris Janton  - face at CentosPrime dot COM
Netminder for Opus1.COM