title: mysql, dump, database restore
body: <p>I have dumped my database with the following command:</p>
  
  <pre><code>mysqldump -uuser -ppassword db_name &gt; file
  </code></pre>
  
  <p>then I completely removed my database:</p>
  
  <pre><code>drop database db_name;
  </code></pre>
  
  <p>then I created a new database:</p>
  
  <pre><code>create database db_name;
  </code></pre>
  
  <p>and then I tried to restore the db with the following command:</p>
  
  <pre><code>mysqldump -uuser -ppassword db_name &lt; file
  </code></pre>
  
  <p>The problem is that dump does not create tables and loads data in them and so the database remains empty however it does show a message like dump completed "date time"</p>
  
  <p>What could be the reason for this?</p>