restart mysqld

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I thought I read somewhere that you could restart the mysqld process -
or at least force it to reread the my.cnf parameters - by sending it a
particular signal with the kill command. I can't find that documentation
now. Is that true and if so what signal is it? TIA

My platform is solaris 10, mysql 5.0,
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with PCLinuxOS - http://enigmail.mozdev.org

iEYEARECAAYFAkfr9N4ACgkQzIf+rZpn0oRrnQCgjwJo9vFpRl aTXY96XPK2GRO4
qjsAn2kfMMlgLDWioWSB9e6WkV47xc0e
=7UQ1
-----END PGP SIGNATURE-----

On Thu, 27 Mar 2008 19:26:21 GMT, Chuck wrote:
>
> I thought I read somewhere that you could restart the mysqld process -
> or at least force it to reread the my.cnf parameters - by sending it a
> particular signal with the kill command. I can't find that documentation
> now. Is that true and if so what signal is it? TIA
>
> My platform is solaris 10, mysql 5.0,

mysqladmin relaod

-u -p and -h as with mysql CLI.

--
Science is like sex:
sometimes something useful comes out, but that's not why we're doing it.
-- Richard Feynman

Peter H. Coffin wrote:
> On Thu, 27 Mar 2008 19:26:21 GMT, Chuck wrote:
>>
>> I thought I read somewhere that you could restart the mysqld process -
>> or at least force it to reread the my.cnf parameters - by sending it a
>> particular signal with the kill command. I can't find that documentation
>> now. Is that true and if so what signal is it? TIA
>>
>> My platform is solaris 10, mysql 5.0,
>
> mysqladmin relaod
>

#v+

· flush-privileges

Reload the grant tables (same as reload).
...
· reload

Reload the grant tables.

#v-

So your answer answers another question:-)


tschazu
erkan


--
über den grenzen muß die freiheit wohl wolkenlos sein