Import database dump

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

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

  • ssh://

yarn import-db --remote-db ssh://

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:

pageImporting remote database


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

yarn import-db ./dump.sql --with-customers-data
yarn import-db --remote-db ssh:// --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

Last updated