I took a dump using mysqldump..
mysqldump -u... -p... mydb t1 > mydb_table.sql
Then I imported the dump in another database having same table, but different records..
mysql -u...-p... mydb < mydb_tables.sql
The importing db had records from primary_key 1 to 1000, and the exporting db had 5000 to 10,000..
But on import the existing records, ie 1 to 1000 got deleted..
How?? Why?? If it a default behaviour, what options I can give to dump to not let it happen next time..