title: Is there a faster way to load mysqldumps?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/67117/speeding-up-mysql-dumps-and-imports">Speeding up mysql dumps and imports</a>  </p>
  </blockquote>
  
  
  
  <p><code>mysqldump</code> is reasonably fast, but dumps of a medium-sized database (20-30 megs) take several minutes to load using <code>mysql my_database &lt; my_dump_file.sql</code></p>
  
  <p>Are there some mysql settings I can tune to speed up the load?  Is there a better way to load saved data?</p>
  
  <p>I've experimented using the mysqlimport utility with CSV-based dumps. These load slightly--but not appreciably--faster.  I'm tempted to just copy raw database files around, but that seems like a bad idea.</p>