title: converting massive extended insert to simple insert for mysql
body: <p>Long story from my weekend with an EC2 instance. Dumped the data I massaged there into a 685MB dump file to move over to my server. Early morning so didn't detect that I had the option set for an extended insert. I don't have access to the massaged data in the temporary database as I figured I was covered with the dump file.</p>
  
  <p>So now I have this dumpfile that includes a table that has one extended insert with 17 million rows. The mysql on my server choked on it.</p>
  
  <p>I did find a perl script called <a href="http://platon.sk/cvs/cvs.php/scripts/perl/mysql/mysqldump-convert.pl" rel="nofollow">mysqdump-convert.pl</a> that converts the extended inserts into simple ones. I piped its output into a new file, but it appears to have choked after 144MB of the 685MB task.</p>
  
  <p>Is there any other tool you know of that can handle this task? Thanks.</p>