# Import database dump

{% hint style="info" %}
Since **magento-scripts\@1.3.0**
{% endhint %}

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

Imports database dump into MySQL container.

{% hint style="warning" %}
Note 1: To be able to import a database dump application must be running.\
Note 2: It is recommended to run the [start](https://docs.create-magento-app.com/v1/getting-started/available-commands/start) command after running database import to ensure that configuration is up-to-date.
{% endhint %}

### **Command options**

#### **`-r, --remote-db`**

{% hint style="info" %}
Since **magento-scripts\@1.6.0**
{% endhint %}

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

* `ssh://`

{% tabs %}
{% tab title="yarn" %}

```bash
yarn import-db --remote-db ssh://my-username@my-server.com
```

{% endtab %}

{% tab title="npm" %}

```bash
npm run import-db -- --remote-db ssh://my-username@my-server.com
```

{% endtab %}
{% endtabs %}

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:

{% content-ref url="../../usage-guide/importing-database/importing-remote-database" %}
[importing-remote-database](https://docs.create-magento-app.com/v1/usage-guide/importing-database/importing-remote-database)
{% endcontent-ref %}

#### `--with-customers-data`

{% hint style="info" %}
Since **mangento-scripts\@1.6.1**
{% endhint %}

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

{% tabs %}
{% tab title="yarn" %}

```bash
yarn import-db ./dump.sql --with-customers-data
yarn import-db --remote-db ssh://my-username@my-server.com --with-customers-data 
```

{% endtab %}

{% tab title="npm" %}

```
npm run import-db ./dump.sql -- --with-customers-data
npm run import-db -- --remote-db ssh://my-username@my-server.com --with-customers-data
```

{% endtab %}
{% endtabs %}

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**:

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

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