Solved

How do I stop this stubborn Mysqld service under Debian?

Posted on 2007-12-02
4
3,839 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
  • 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Squid Connection Pools 3 67
AWS- KeepAlived notify script not working 23 78
Check if a filw is immutable for a certain amount of time 6 61
AWS - HAProxy- KeepAlived 5 41
SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now