Solved

How do I stop this stubborn Mysqld service under Debian?

Posted on 2007-12-02
4
3,830 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
Comment Utility
pkill -9 mysqld
0
 
LVL 14

Expert Comment

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

Author Comment

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

Author Comment

by:potworny
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Over the last ten+ years I have seen Linux configuration tools come and go. In the early days there was the tried-and-true, all-powerful linuxconf that many thought would remain the one and only Linux configuration tool until the end of times. Well,…
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 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

10 Experts available now in Live!

Get 1:1 Help Now