title: Convert Mysql Dump File from INSERT to INSERT IGNORE
body: <p>I have a huge dump file about 40G in size, and I need to dump that back into the database since there are some records are missing after a recovery.
  Is there any easy way I can covert the INSERT into INSERT IGNORE in the dump file to avoid duplicate entries errors? loading the file to a text editor seems a no go to me.
  thank you very much in advance</p>