Import database dump

Since magento-scripts@1.3.0

yarn import-db [dump file path] or npm run import-db [dump file path]

Imports database dump into MySQL container.

Note 1: To be able to import a database dump application must be running. Note 2: It is recommended to run the start command after running database import to ensure that configuration is up-to-date.

Command options

-r, --remote-db

Since magento-scripts@1.6.0

Imports database from the remote server. Currently, the following protocols are supported:

• ssh://

yarn

yarn import-db --remote-db ssh://[e-mail]

npm

npm run import-db -- --remote-db ssh://[e-mail]

Now it will connect via ssh to your server, create dump files (dump-0.sql and dump-1.sql), download them to your projects root folder, merge them into single dump.sql and import to your local instance with applied fixes.

To learn more about this option, read the following guide:

Importing remote database

--with-customers-data

Since mangento-scripts@1.6.1

Does not exclude customers and orders data when importing local and remote database.

yarn

yarn import-db ./dump.sql --with-customers-data
yarn import-db --remote-db ssh://[e-mail] --with-customers-data 

npm

npm run import-db ./dump.sql -- --with-customers-data
npm run import-db -- --remote-db ssh://[e-mail] --with-customers-data

If you are importing a remote database and using this option, CMA will create only one dump.sql file with all data inside it.

Usage example:

yarn import-db ./dump.sql
... # output

# or with npm
npm run import-db ./dump.sql
... # output