I have a CMD prompt script that will dump only the data from my database (dbjobs):
mysqldump -u 'username' -p'password' --no-create-info --complete-insert dbjobs > c:/database_data_only.sql
But when I try to restore the data, I get multiple errors:
ERROR 1062 (23000): Duplicate entry '1' for key 1
Is there something that I can add to the mysqldump command that will solve this issue?