How to get an import of a very large Drupal database working? I'm using Vagrant and OracleVM to run Drupal 7. I've got the site up and running and I'm trying to get my database imported. So far I've run drush cc and cleared the drush cache, and then I did 

drush sql-cli &lt; mydb.sql


The drush command is taking a super long time and I'm not sure if it's even doing anything. The database file is just under a gigabyte.

What can I do to get this working, or is there a better method?
I'm not sure how much overhead drush puts on top of large SQL imports, I've only used it for smaller imports and queries. You can try the mysql client as an alternative that would remove the drush overhead.

If you can install pipe viewer on your VM you can view the progress of the command consuming the import.

pv mydb.sql | drush sql-cli


Or without the drush overhead

pv mydb.sql | mysql -u &lt;DB_USER&gt; -p&lt;DB_PASS&gt; &lt;YOUR_DB&gt;