Solved

How do I stop this stubborn Mysqld service under Debian?

Posted on 2007-12-02
4
3,856 Views
Last Modified: 2013-12-16
Hi,

The question is very simple.
I would like to upgrade my Mysql.
But the aptitude program failed to stop Mysqld saying:

<quote>
Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 1
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
</quote>

What do I do in order to stop the Mysql database?

The following also fails:

# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld failed!

Anyone? Any ideas? :)

Best regards,
Terrible Johnny
0
Comment
Question by:potworny
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 14

Accepted Solution

by:
arrkerr1024 earned 250 total points
ID: 20393079
pkill -9 mysqld
0
 
LVL 14

Expert Comment

by:arrkerr1024
ID: 20393081
pkill kills processes by name, the -9 sends a SIGKILL signal which will force it to immediately quit.
0
 

Author Comment

by:potworny
ID: 20398986
Why do I have a feeling that data may be lost when killing mysqld?
0
 

Author Comment

by:potworny
ID: 20406287
I used the following solution:

killall -w mysqld

The database closed and therefore I was able to upgrade it. But I still have a feeling that it was unsafe...
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How many times have you wanted to quickly do the same thing to a list but found yourself typing it again and again? I first figured out a small time saver with the up arrow to recall the last command but that can only get you so far if you have a bi…
Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question