PDA

View Full Version : How to properly restart mysql


ssslippy
16 Apr 2008, 07:22
What is the proper way to restart mysql without screwing up current database queries.

SEOvB
16 Apr 2008, 08:50
service mysql restart

Paul M
16 Apr 2008, 09:04
I think you mean service mysqld restart

Dismounted
16 Apr 2008, 09:11
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
16 Apr 2008, 10:07
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
16 Apr 2008, 10:35
It all depends on how the server is setup and the OS used.

mlx
16 Apr 2008, 12:21
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
16 Apr 2008, 12:24
Its always been mysqld on servers I have used. :)

wolfstream
22 Apr 2008, 15:01
service mysql restart

I think you mean service mysqld restart

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