title: Is there a way to check loading status of dump mysql import?
body: <p>I'm using the command below to import a backup.sql in mysql Docker container:</p>
  
  <p><code>cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE</code></p>
  
  <p>That works well, but sometimes the import takes a long time because of the size of the sql file dump. (~10 minutes or even more).</p>
  
  <p>Is there any way I can check the status (loading percentage or something helpful) of the restore?</p>
  
  <p><strong>TLDR:</strong> Use the command template below replacing your settings.</p>
  
  <p><code>pv -pert &lt;sql file&gt; | docker exec -i &lt;container&gt; /usr/bin/mysql -u &lt;user&gt; --password=&lt;password&gt; &lt;DATABASE&gt;</code></p>