Error Code : ERROR 1022 (23000) at line 27: Can't write; duplicate key in table
This actually means, you cannot reference the key with the same name in the same schema. I renamed the table name properly, however I did not change the key name. Recreating a different table with the same foreign key resulted me this error.
Solution: Renamed the foreign key name as well. After which data was pushed successfully.