Solved

How do I stop this stubborn Mysqld service under Debian?

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ftp to port 21 4 69
maybe no no httpd.conf 6 79
Linux Real Time Memory on Distinct 24 Cycle 7 44
simple bash script needed to unpack tar.gz 4 28
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…
Using 'screen' for session sharing, The Simple Edition Step 1: user starts session with command: screen Step 2: other user (logged in with same user account) connects with command: screen -x Done. Both users are connected to the same CLI sessio…
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

733 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