Hello, I'm using the 3.23.46 mysql binary kindly supplied by Marc Liyanage (www.entropy.ch/software/macosx/) on OS X 10.1.1.
Maybe 1 out of 5 tries mysqladmin shutdown fails, timed-out waiting for the pid file it says. mysqladmin doesn't return and I have to either use ^C or open a new window and kill mysqladmin to get terminate it and get the error. After that the mysql sock file is gone (so I may no longer connect) but the pid file remains and I have to kill -9 safe_mysqld and mysqld then run isamchk. Here's what I'm doing: -- Development on a laptop; no one else connecting to the DB -- I make certain nothing is working against the DB before trying to shutdown -- Most db queries coming through PHP4.0.6 all else through mysql cli -- start from /usr/local/mysql using sudo bin/safe_mysqld --user=mysql & -- stop with mysqladmin -u root -pppassword shutdown -- Being on a laptop, mysql sometimes sees the host as localhost and sometimes as dhcp-* host. -- I've noticed I get different .pid and .err files depending on host -- Hosts are switching mid-stream (I always shutdown myslq before going on/off a network) I've been through books and website, but I haven't been able to resolve what I'm doing wrong. . . mysql has been really great to have on the laptop and I'm hoping someone could help through this one problem. Thanks in advance, Steve Fox UT CMHC --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
