Did you shut down mysqld or read lock before copying the table?
Qunfeng wrote:
Hi,
I am running MySQL 4.1.8-Max-log on two Linux machine (machine A and
machine B). In the past, I do a simple scp to transfer all the
database table file from one machine (A) to the other (B). After the
No, I didn't shut down mysqld or read lock. Would you please elaborate it a
little more on why? Thanks a lot!
Qunfeng
At 01:05 PM 5/27/2005, Eric Bergen wrote:
Did you shut down mysqld or read lock before copying the table?
Qunfeng wrote:
Hi,
I am running MySQL 4.1.8-Max-log on two Linux
If you are copying a file that mysql is writing to sections of the file
are going to be from different points in time so when that all gets put
backtogether in one file on the other end it's going to be corrupt.
Qunfeng wrote:
No, I didn't shut down mysqld or read lock. Would you please
But while I copied all the table files from A (testing machine) to machine
B (real server), no data was writing into A's tables.Are you saying
that I have to shut down the mysqld on machine A or activate WRITE lock to
A before copying over to machine B?
Qunfeng
At 02:52 PM 5/27/2005,
Haitao Jiang [EMAIL PROTECTED] wrote:
I have done following on a 8 million row table (4GB):
repair table
optimize table
drop one of the fulltext index
optimize table again
Now fulltext search stop working and I am getting:
ERROR 1030 (HY000): Got error 127 from storage engine
What
Did you try to repair it again and use myisamchk -r table.MYI
Did you check your .err file (log)
_
Steve Poirier
-Original Message-
From: Haitao Jiang [mailto:[EMAIL PROTECTED]
Sent: August 6, 2004 1:21 PM
To: [EMAIL PROTECTED]
Subject: ERROR 1030