Hi all. I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or so now, and have noticed that the command: mysqladmin shutdown -ppassword doesn't shut down all mysql processes. I use the following script to backup our database and restart mysql:
--- cd /root/sql/backups for I in EnergyShop NUS ebills irm mysql sales Fuel do /usr/local/mysql-4.0.3/bin/mysqldump -v --opt $I > $I.dump -pPASSWORD done /usr/local/mysql-4.0.3/bin/mysqladmin shutdown -pPASSWORD /usr/bin/nice -n -10 /usr/local/mysql-4.0.3/bin/mysqld_safe --enable-locking --log-update --log-slow-queries -- log-long-format & cd .. tar -ycvf backups.tar.bz2 backups --- If you're wondering why I shutdown & restart the server - I used to have a problem with telling mysql to start another log file after backing up the database. I'm not sure whether this was a bug or just my lack of understanding, but anyway it worked so I used it... The script used to work with MySQL-4.0.1 and MySQL-4.0.2 but now I get processes hanging around, usually 'mysqld_safe' and 1 or 2 'mysqld' processes. This appears to happen whether I leave a client connected or not. Under previous versions, if I left a client running (eg mysqltop - accidentally of course), mysql would shut down and mysqltop would loose it's connection - which is what I had expected to happen. So I'm not sure whether mysql keeps running because there are client connections still open (MS Access sometimes doesn't disconnect properly, and we have 40 MS Access clients...). So ... Is this behaviour expected if clients are leaving connections open? Has this behaviour been changed intentionally since MySQL-4.0.2? Is this likely to cause a problem? I have had to kill the processes with kill -9. There is nothing in the transaction or error log at all. And I haven't noticed any data corruption yet. Thanks in advance! -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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
