title: MySQLDump one INSERT statement for each data row
body: <p>with the following statement:</p>
  
  <pre><code>mysqldump --complete-insert --lock-all-tables --no-create-db 
  --no-create-info --extended-insert --password=XXX -u XXX 
  --dump-date yyy &gt; yyy_dataOnly.sql
  </code></pre>
  
  <p>I get INSERT statements like the following:</p>
  
  <pre><code>INSERT INTO `table` VALUES (1,'something'),(2,'anything'),(3,'everything');
  </code></pre>
  
  <p>What I need in my case is something like this:</p>
  
  <pre><code>INSERT INTO `table` VALUES (1,'something');
  INSERT INTO `table` VALUES (2,'anything');
  INSERT INTO `table` VALUES (3,'everything');
  </code></pre>
  
  <p>Is there a way to tell "mysqldump" to create a new INSERT statement for each row?
  Thanks for your help!</p>