Exporting db

Problem

How to export database

Solution

To import database in terminal you can do the folloing:

mysqldump database_nameĀ > database_exportname.sql

Export all databases

mysqldump --all-databases > all_databases_export.sql

Exporting database using drush

drush sql-dump > ~/my-sql-dump-file-name.sql