dbTalk Databases Forums  

Stopping Mysql started with mysqld_safe

comp.databases.mysql comp.databases.mysql


Discuss Stopping Mysql started with mysqld_safe in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
salvador
 
Posts: n/a

Default Stopping Mysql started with mysqld_safe - 08-02-2006 , 01:53 PM






The INSTALL-BINARY file that came with my version of mysql recommends
that you start mysql using "bin/mysqld_safe --user=mysql &" which works
great to keep the database humming along.

But nowhere have I been able to find how to safely shut down the
database server. I recently made the big mistake of killing the
mysqld_safe process and then killing the mysqld processes, which
corrupted 2 of my databases. Thankfully, I recovered them with
myisamchk, but it was pretty scary for awhile.

What's the recommended way to (safely) stop mysql when started with
mysql_safe?

Thanks,

Sal


Reply With Quote
  #2  
Old   
Jerry Stuckle
 
Posts: n/a

Default Re: Stopping Mysql started with mysqld_safe - 08-02-2006 , 02:49 PM






salvador wrote:
Quote:
The INSTALL-BINARY file that came with my version of mysql recommends
that you start mysql using "bin/mysqld_safe --user=mysql &" which works
great to keep the database humming along.

But nowhere have I been able to find how to safely shut down the
database server. I recently made the big mistake of killing the
mysqld_safe process and then killing the mysqld processes, which
corrupted 2 of my databases. Thankfully, I recovered them with
myisamchk, but it was pretty scary for awhile.

What's the recommended way to (safely) stop mysql when started with
mysql_safe?

Thanks,

Sal

mysqladmin shutdown

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.