Is there a better way to shutdown MySQL?

[Anon]

hi,

i have redhat linux 6.2 running on my PC with PHP3 and MySQL.
whenever i shutdown the system i do not explicitly stop the mysql daemon.
is this ok?

is it necessary for me to "mysql stop" before "halt"?

thanx for any reply
steve

[[deleted]]

First, a HALT is hardly a nice way to shutdown linux.
Changing to init state zero is more polite.

If your system is properly installed, it should shutdown everything (including MySQL) automatically through the init.d system, just like it is started at boottime.

So the next question is: how did you install MySQL in the first place?

[Anon]

hi,

thanx for the advice. what i wanted to know was is there any problem at all when the system is shutdown without closing mysql first (data loss etc)?

and by the way, i installed mysql with rpm's

steve

[[deleted]]

Ofcourse there can be problems if you brutally kill MySQL.
Is there any program out there that can stand being killed without any risks?

If you installed the RPM versions, it probably installed the start/stop routines too, and a proper shutdown (init 0) will shutdown mysql nicely.