mysqldump - How to restore data from MYSQL dump without any duplicate key errors? -


Every time I try to restore the dump, I get:

error 1062 (23000) Line 10297: Duplicate Entry 'Spash' for Key 'Primary'

I'm trying to restore it by using:

 < Code> mysql -u root-popassword database & lt; 0719.sql  

You can import dumps in a temporary table, a SQL statement To make a copy of the rows from this temporary table, which are not found in the target table.


Comments