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
transferring, the table on B works well.
However, I am encountering a problem with transferring a big table
(with 11 million record). The table in A works but seems to be
corrupted after transferrring to B. When querying on the table at B, I
got "Got error 127 from storage engine".
I tried myisamchk -r tablename but I still got the same msg. Any idea?
Thanks in advance!
Qunfeng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
