Convert Mysql Dump File from INSERT to INSERT IGNORE

Question

I have a huge dump file about 40G in size, and I need to send it back to the database, because after the restoration some records are missing. Is there an easy way I can hide INSERT in INSERT IGNORE in a dump file to avoid duplicate entries? loading a file into a text editor seems impossible to me. thank you very much in advance

Answer 1

If you are using a UNIX-like operating system, you can use sed :

 cat file.sql | sed s/"^INSERT"/"INSERT IGNORE"/g > updated.sql 

Answer 2

There is also a switch for mysqldump

- insert-ignore in mysqldump

Answer 3

Use a text application, such as sed , from the command line to replace the import search.