Ignore errors in mysql by reading from some MySQL dump [duplicate]

Question

I got an MySQL dump with ONLY insert statements. I tried to import it like this:

mysql> \. racktablesTabellen.sql

which always worked for me, till now because I got some errors I have to ignore. Can anybody tell me how to Ignore errors and just keep on with the entries when I got an sql dump with only insert statements ?

Primary Key duplicate errors. Basically I just want to ignore them and keep on with the other entries. — BoJack Horseman
– BoJack Horseman, Commented Apr 3, 2014 at 10:08
But how can I put that IGNORE in there ?? It's just got a dump with thousands of lines with INSERT statements Oo — BoJack Horseman
– BoJack Horseman, Commented Apr 3, 2014 at 10:11

blue · Accepted Answer · 2014-04-03 10:17:06Z

1

A possible solution is to remove the PRIMARY KEY from your table, import and add the PRIAMRY KEY again with ALTER IGNORE syntax.

answered Apr 3, 2014 at 10:17

blue

1,9471 gold badge11 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

BoJack Horseman Over a year ago

Your answer might work as well but I am too dumb to check the syntax xP I just did this in my vi :%s/INSERT/INSERT IGNORE worked I guess

develCuy Over a year ago

I did this based off previous comment: zcat db.sql.gz | sed -e 's/INSERT/INSERT IGNORE/' | mysql -u user -p dbname

Collectives™ on Stack Overflow

Ignore errors in mysql by reading from some MySQL dump [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related