[EMAIL PROTECTED] wrote:
>> Description:
>
>
>
> I'm new to MySQL, and am porting an application from msql. Apologies
> in advance for blatant ignorance on my part.
>
> Apparantly the code that increments the counter on whether
> a table has been modified is broken. myisamchk reports that:
>
> "myisamchk: warning: 1 clients is using or hasn't closed the
> table properly"
>
> when I don't think it should. Also, note that the configuration
> is somewhat non-standard.
>
>
>> How-To-Repeat:
>
>
>
> mysqladmin create foo
> echo "CREATE TABLE try ( user CHAR(9), message TEXT) \g" | mysql foo
> echo "INSERT INTO try VALUES ('hi', 'sailor') \g" | mysql foo
> myisamchk /usr/local/storm/MySQL/var/foo/*.MYI
>
>
Don't run myisamchk while the server is running.
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
