title: How long should a 20GB restore take in MySQL? (A.k.a. Is something broken?)
body: <p>I'm trying to build a dev copy of a production MySQL database by loading one of the backups. How long should it take to do this if the uncompressed dump is ~20G?</p>
  
  <p>This command has been running for something like 24h with 10% CPU load and I'm wondering if it's just slow or if it/I am doing something wrong.</p>
  
  <pre><code>mysql -u root -p &lt; it_mysql_dump.sql 
  </code></pre>
  
  <hr>
  
  <p>BTW it's on a beefy desktop dev machine with plenty of ram, but it might be reading and writing the same HDD. I think I'm using InnoDB.</p>