> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.xynta.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Import a Database Dump or Backup

||| ℹ️ **Note:** This article applies to our Web and Reseller Hosting packages.
---

* [Via DirectAdmin (recommended)](#4-via-directadmin-recommended)
* [Via phpMyAdmin](#4-via-phpmyadmin)
* [Via SSH](#4-via-ssh)
* [Instructional Video](#3-instructional-video)
---

### Importing a database dump or backup

#### 📥 Via DirectAdmin (recommended)

1. Log in at `https://voorbeeld.cc:2222` (or use [Single Sign-On (SSO)](/en/article/logging-in-to-hosting-package-via-single-sign-on-sso-1biycbb/)).
2. Under **Account Manager**, click **Databases**.
3. In the overview, click **Manage** next to the correct database.
4. Scroll down and click **Import**.
5. Choose the `.sql` file you want to import and click **Upload**.
6. Choose whether to delete existing data:

* Click **YES** to delete existing data (recommended for full backups).
* Click **NO** to keep existing data.

7. The database will now be imported. This may take a few minutes.

#### 📥 Via phpMyAdmin

1. Log in at `https://voorbeeld.cc:2222` (or use [Single Sign-On (SSO)](/en/article/logging-in-to-hosting-package-via-single-sign-on-sso-1biycbb/)).
2. Under **Account Manager**, click **Databases**.
3. In the overview, click **Manage** next to the correct database.
4. Click **PHPMYADMIN** in the top right corner.
5. Select the database name on the left.
6. Click the **Import** tab.
7. Click **Choose File** and select the `.sql` file.
8. Scroll down and click **Import** to upload the file.

#### 📥 Via SSH

1. Upload the database backup to the `/` folder on your hosting package (via FTP or [File Manager](/en/article/using-file-manager-on-your-hosting-package-n5qi07/)).
2. Connect to your hosting package using SSH.
3. Enter the following command:
 
```
mysql -u[database_user] -p [database_name] < [database_backup].sql
```
 
4. Press Enter.
5. Enter the password for the database user and press Enter again.
6. The database will now be imported. This may take a few minutes.

| 📌 Important:

* Replace voorbeeld.cc with your own domain name.
* Replace [database_user] with your database user.
* Replace [database_name] with your database name.
---

### 🎦 Instructional Video

${youtube}[](Pgnx-0OaLDI)