title: Moving a mysql database from one vps to another
body: <p>I'm moving a large wordpress mysql db (1.49gb) from an old server to a new one, what I did was to:</p>
  
  <pre><code>mysqldump -u root -p dbname &gt; public_location/db.sql
  </code></pre>
  
  <p>then I did a:</p>
  
  <pre><code>wget http://oldserver/db.sql
  </code></pre>
  
  <p>I created the database on the new server, created the user, then:</p>
  
  <pre><code>mysqldump -u root -p dbname &lt; db.sql
  </code></pre>
  
  <p>It says dump completed, but why is the database on the new server still empty? I don't see any tables at all.</p>