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 if you're using it to repair tables, because then if you have both myisamchk and the server writing to the table files, you're not going to like the results.
However, even with checking, if you don't flush the tables, you may see spurious warnings of inconsistencies. (Due to unflushed changes, for example.) These do not result in table damage.
At 14:37 -0400 8/21/03, Luc Foisy wrote:
If you read http://www.mysql.com/doc/en/Maintenance_regimen.html they say something interesting that would contracdict other places in the documentation
They actually recomend running myisamchk on a running instance of mysqld. The method on that page (a method they use themselves) would not even allow a flush tables to be called before.
Strange... How many answers can I find to this, does anyone know? I have several conflicting sources now
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, 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 changes still in the server's buffers. Running myisamchk in that case can make the tables *in*consistent because the tables won't have in them what the server thinks.
Don't do it.
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 you are running myisamchk. In MySQL Version 3.23 the easiest way to avoid this problem is to use CHECK TABLE instead of myisamchk to check tables.
Or is that only to avoid seeing: myisamchk: warning: 1 clients is using or hasn't closed the table properly
Its very important that I get an answer soon... Please and Thank you
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
