title: mysqlimport using dump
body: <p>I need to restore a dumped database, but without discarding existing rows in tables.</p>
  
  <p>To dump I use:</p>
  
  <pre><code>mysqldump -u root --password --databases mydatabase &gt; C:\mydatabase.sql
  </code></pre>
  
  <p>To restore I do <em>not</em> use the mysql command, since it will discard all existing rows, but instead mysqlimport should do the trick, obviously. But how? Running:</p>
  
  <pre><code>mysqlimport -u root -p mydatabase c:\mydatabase.sql
  </code></pre>
  
  <p>says "table mydatabase.mydatabase does not exist". Why does it look for tables? How to restore dump with entire database without discarding existing rows in existing tables? I could dump single tables if mysqlimport wants it.</p>
  
  <p>What to do?</p>