The reason we run the check scripts is because in the past we had all sorts
of trouble not with the daemon crashing, but with clients (who have no
technical skills) using Access & ODBC to update tables, and somehow
corrupting them. This way we catch the problems before the client does.
Thanks though. I'll give it a go.
Don
On Wednesday 07 March 2001 17:16, Dan Nelson wrote:
> In the last episode (Mar 07), Don Bowyer said:
> > I recently upgraded our database from 3.22.32 to 3.23.32 We run a
> > ISAM check every night, to check for db problems. Ever since I did
> > the change, I get a email from the cron daemon like this:
> >
> > /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI
> > /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the
> > table properly
>
> The database is shut down when you do this, right? You should really
> never have to run myisamchk unless your server crashes a lot. If you
> don't want to shut down mysql to check tables, use the "CHECK TABLE"
> mysql command.
--
Insidewire Services Inc.
www.insidewire.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
