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 -0400 8/21/03, Luc Foisy wrote:
Thank you Paul.
whew! So just checking will not do
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
)
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 server's buffers.
Running myisamchk
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 no
, 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?
Yes, you may have unflushed
)
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 server's buffers.
Running myisamchk
...
-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 mind
: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
fashion. The problems occur
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 not
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 no one is using the tables while
10 matches
Mail list logo