MySQL Dump / Restore (Data Only)

[kool_samule]

Hi Chaps,

 

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:

e.g.

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?

[shlumph]

There may be an option to include drop statements, not sure off the top of my head though

[kool_samule]

Hi, thanks for the reply, I found TRUNCATE, but don't think you can add it to the dump options ????

[shlumph]

Try this:

mysqldump -u 'username' -p'password' --add-drop-table --no-create-info --complete-insert dbjobs > c:/database_data_only.sql

[kool_samule]

thanks for the reply, I think I'll dump the data only, then when restoring the data, truncate the tables, then load the data