--- Bill Adams <[EMAIL PROTECTED]> wrote: > > One option is to use > > > > /usr/local/mysql/bin:mysql$ mysqladmin -u root -p shutdown > > > > But this one doesn't work for me, even though I am using the proper > > password and am the proper user. Executing this command just > leaves me > > hanging at the prompt (and the only way to get out of the hang is > to > > either suspend the job, which also has no effect). > > Do you have a query still running? E.g. does mysqladmin -uroot -p > processlist show any locks? If so, can you kill the thread with > mysqladmin > kill?
Bill, First of all, thanks for responding -- I'm a bit worried about this problem (since I can't come across a logical solution yet). Being new to MySQL, I hadn't checked for running processes, but I just tried your command: mysql:localhost~:$ ../bin/mysqladmin -u root -p processlist Enter password: +----+------+-----------+----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+----+---------+------+-------+------------------+ | 4 | root | localhost | | Query | 0 | | show processlist | +----+------+-----------+----+---------+------+-------+------------------+ mysql:localhost~:$ I'm assuming that this says that the only query is the actual "processlist" command itself, so it doesn't need to be killed. Any other ideas? Erik PS: If I run the mysqladmin shutdown command, then check "top" in another console, both the daemon and the mysqladmin command continue to run indefinitely -- and I have waited an hour to see if it's just slow. That doesn't seem to be the case. __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com --------------------------------------------------------------------- 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
