# Create Backup · Backup And Restore · Getting Started

Export the PostgreSQL databases from the database container and copy the SQL backup to the Mint host.

Canonical: https://docs.mintsd.com/docs/mint-service-desk/getting-started-create-backup
Language: en-GB
Revision: 2a2d39f1e31deba465d9905cd685a5a3416966a588eb6151bba19ba5bc3c7cc9

<a id="element-01a1452d-ebdb-7552-b202-f24f2e1b6c58"></a>

Open a shell in the database container:

<a id="element-01a1452d-ebdc-7da0-b7fd-a871d2adbbf7"></a>

```default
docker exec -it id_container /bin/sh
```

<a id="element-01a1452d-ebdd-7a64-b513-ed140984e24d"></a>

Replace `id_container` with the database container ID. Inside the container, run:

<a id="element-01a1452d-ebde-7da1-9407-baf6d8954299"></a>

```default
pg_dumpall -U postgres --filename.sql
```

<a id="element-01a1452d-ebdf-7db9-87e5-54705366b6b3"></a>

`filename.sql` is the name of the SQL backup file.

<a id="element-01a1452d-ebdf-742a-a6af-13a164bc5ad4"></a>

Exit the container:

<a id="element-01a1452d-ebe0-76e8-95d2-c2dd45bb02ba"></a>

```default
exit
```

<a id="element-01a1452d-ebe0-7a61-a3cb-682f744f8646"></a>

On the host, run:

<a id="element-01a1452d-ebe2-7091-97c5-bde2c85ab81a"></a>

```default
docker cp id_container:/filename.sql .
```

<a id="element-01a1452d-ebe2-7143-92c2-a94d14008172"></a>

`docker cp id_container:/filename.sql .` copies the database backup to the Mint host.

