mysql how to restore data for part of a table

Let's say I have table A, it has 3000 rows and I know the first 2000 rows are corrupt and I have a clean records sitting in another m开发者_运维知识库ysql server. What would be the easiest way to restore that 2000 rows? Thanks so much.

Using Maatkit's mk-table-checksum tool you can determine the differences between the tables of two hosts.

mk-table-sync is used to generate and/or run only the statements necessary to update the corrupted table.

What you want is to copy the mysql file from the backup server and delete the file on the production server.