How to properly restart mysql

[ssslippy]

What is the proper way to restart mysql without screwing up current database queries.

[SEOvB]

service mysql restart

[Paul M]

I think you mean service mysqld restart

[Dismounted]

I always forget to put the "d" on at the end when I'm going through commands fast :p. Another method is:
/etc/init.d/mysqld restart

[SEOvB]

I think you mean service mysqld restart

Sure if the server is setup to recognize mysqld rather then mysql.

On a sidenote, is mysqld the correct way for the server to recongnize it? I've got mine set for service mysql restart and that works, and mysqld is unrecongized service.

:confused:

[Marco van Herwaarden]

It all depends on how the server is setup and the OS used.

[mlx]

I believe the stock CentOS RPMs setup the service as "mysqld" and the RPMs from mysql.com will set it up as "mysql", or was it the other way around?

Anyway, both ways should be fine and it really doesn't matter, just a question of which binary you use I guess.

[Paul M]

Its always been mysqld on servers I have used. :)

[wolfstream]

service mysql restart

I think you mean service mysqld restart

Either option will work. In some it's mysqld, in some it's mysql