Drush is the ultimate tool and companion for Drupal and it does a great job in situations where we want to import or export our Drupal database.
Export/Backup Drupal database with Drush
The best way to export the Drupal database is to first rebuild/clear the cache first and then export DB with sql-dump command. Clearing the cache first will empty the cache tables in the database and significantly decrease the database size.
Export Drupal 8 database
- The first step is to rebuild your cache before database export
drush cr
- Now run the sql-dump command with the destination argument to export the Drupal 8 database to the desired location. This will dump the database into a gzip file without cache table content.
drush sql-dump --gzip --result-file drush sql-dump --gzip --result-file=/path/to/file.sql
Export database in Drupal 6 or 7
- For Drupal 6 and 7 also, you need to clear the cache first to empty the cache from the database.
drush cc
- Now run the sql-dump command to export the Drupal 6 and 7 databases. The export will be a gzip file without cache table content.
drush sql-dump --gzip --result-file drush sql-dump --gzip --result-file=/path/to/file.sql
Import Drupal database with Drush
The below command can be used to import an SQL dump file into the Drupal database. Make sure to drop the database first and then run the import command which will import the data to Drupal's current database.
drush sql-drop -y
drush sql-cli < ~/path/to/file.sql