From: Dan Nelson Date: November 16 2001 8:29pm Subject: Re: shutdown still a problem on Darwin List-Archive: http://lists.mysql.com/mysql/91544 Message-Id: <20011116202921.GB95212@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii In the last episode (Nov 16), Erik Price said: > --- Dan Nelson wrote: > > As long as there are no active connections, killing mysql will not > > affect the database. If you kill mysql during an update, you risk > > corrupting any indexes on the tables being modified. If your > > tables are BDB or InnoDB format, you should be able to kill mysql > > at any time without damaging your tables. > > What about the mysql database itself -- the grant tables? I'm the > only user right now (and my partner will join a bit later on), but I > my project won't go "public" until it gets onto a more stable server, > so I'm not worried about any connections being open, but won't the > grant tables be accessed when I execute mysqladmin shutdown? Oh... > right, I'm not executing that. Alright, that's good news! Thanks! Reads don't modify the tables anyway. You only have to worry about killing mysql during an update. -- Dan Nelson dnelson@stripped