Hey, I thought you could just use
mysqladmin refresh -pPASSWORD -- or mysqladmin reload -pPASSWORD To kickstart logging again? If not - hey, what do I know <heh> Eric Lamendola At 11:12 AM 9/10/02 +1000, Daniel Kasak wrote: >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 --------------------------------------------------------------------- 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
