title: Import .sql file using multiple threads?
body: <p>I have a huge SQL file (around 69GB). I want to import it into my local database. All tables are InnoDB engine based.</p>
  
  <hr>
  
  <p>I have tried standard ways of importing</p>
  
  <pre><code>mysql -u*** -p**** db_name &lt; dump.sql
  </code></pre>
  
  <p>and</p>
  
  <pre><code>source /location/dump.sql
  </code></pre>
  
  <p>but these take too much time.</p>
  
  <hr>
  
  <p>Is there any way in SQL or Python that we can create multiple threads corresponding to diff tables and import them? Is there any other method that can speed up the process?</p>