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 transferring,
the table on B works well.
However, I am encountering a problem with
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
Hi,
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 does this mean? Index corrupted? How
(HY000): Got error 127 from storage engine
Hi,
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