title: Restore of MySQL Backup just stuck
body: <p>I have a with mysqldumb created backup file. It's about 15GB and contains a lot of blobs. Max size per blob is 30MB.  </p>
  
  <pre><code>mysqldump -uuser -ppass --compress --quick --skip-opt supertext &gt; supertext.sql
  </code></pre>
  
  <p>Now when I try to restore the backup, the process just gets stuck.  </p>
  
  <pre><code>mysql -uuser -ppass dev_supertext &lt; supertext.sql 
  </code></pre>
  
  <p>It get stuck while writing back the biggest table with the blobs. There is no error message and mysql is still running fine. </p>
  
  <p>This is on a 64bit 5.1.48 community edition for Windows server. </p>
  
  <p>max_allowed_packet is set to 40MB and is not the problem. I had that before. </p>
  
  <p>Any other settings I could check or something I can monitor during the restore? 
  Didn't see anything special in the query or error log. Maybe there is a timeout?</p>
  
  <p>Just FYI:
  I've already posted this question in the MySQL Forum, but got no response.
  <a href="http://forums.mysql.com/read.php?28,377143" rel="nofollow noreferrer">http://forums.mysql.com/read.php?28,377143</a></p>
  
  <p>Thanks for any tips.</p>