k multiple databases with 20 or 30 tables each.
myisamchk is a great deal more easier to use.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 5:00 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
At 16:32 -0
Hi!
On Aug 21, Luc Foisy wrote:
> Thank you Paul.
> whew! So just checking will not do anything to the database, in an case?
yes, but ONLY if you run myisamchk with --read-only flag.
> I am not really caring if it returns the "# users still connected/ or
> table not closed right" warning. I am n
ursday, August 21, 2003 3:08 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
I should qualify my answer, to indicate something that may not apply
to the situation you have in mind.
If you're using myisamchk only to *check* tables, it operates in read-only
f
corrupted...
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 3:08 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
I should qualify my answer, to indicate something that may not apply
to the situation you have in
; MYSQL-List (E-mail)
Subject: Re: myisamchk question (important)
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Yes, you may have unflushed changes still in th
esday, August 20, 2003 10:06 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: Re: myisamchk question (important)
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Ye
Luc Foisy unknowingly asked us:
Would anything happen to the database if I ran "myisamchk --silent /usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
As it states in the documentation:
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and ensure that n
)
Subject: Re: myisamchk question (important)
At 9:54 -0400 8/19/03, Luc Foisy wrote:
>Would anything happen to the database if I ran "myisamchk --silent
>/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Yes, you may have unflushed changes still in the
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
Yes, you may have unflushed changes still in the server's buffers.
Running myisamchk in that case can make the tables *in*cons
