title: mysqldump line timeout issues
body: <p><strong>Similar to:</strong> <a href="https://stackoverflow.com/questions/1293529/how-to-deal-with-enormous-line-lengths-created-by-mysqldump">Only getting a friendlier mysqldump isn't possible.</a></p>
  
  <p>My webhost kicked my database off so the latest backup I have is their mysqldump. In other words, <code>--extended-insert=FALSE --complete-insert=TRUE</code> isn't possible, I already have the mysqldump.</p>
  
  <p>The issue I'm having is that re-importing that onto my webhost phpmyadmin times the poor guy out. Reasonably so. It can easily handle a 40,000 inserts, but not as a single insert of them all in a row.</p>
  
  <p><strong>Problem: I'm struggling with figuring out how to break these into separate queries.</strong></p>
  
  <p>I've already tried going through every single one and find-replacing, but, as expected, I made mistakes (and it cost me 10 hours) and I'm better off starting over again that trying to figure out where I messed up in this massive file. </p>
  
  <p>The long lines look like this: </p>
  
  <pre><code> INSERT INTO `TABLE_UNICORNS` VALUES ('user',0),('user',1),('user',2),...,('user',20000);
  </code></pre>
  
  <p>I do have MSSQL management studio, but I'm queasy about importing a MySQL database into MSSQL and spitting back out MySQL. I can also get the MySQL dbms (I'm on windows). The only other solution I could rack my brain for is a programmatic solution, but I'm queasy about that, too. <em>(I'm not disqualifying solutions, merely thinking aloud to demonstrate that I am trying on my own).</em></p>