You need to have:

- Access to the cPanel of your hosting account.
- SSH access enabled (if you don't have it, request it from your hosting provider).
- The `.sql` backup file already uploaded to the server (via FTP or through the cPanel File Manager).
- A MySQL user with permissions on the database.

**​**

**1. Log in to your cPanel**  
Go to: `yourdomain.com/cpanel`  
Enter your username and password.

**2. Create the database and the MySQL user**  
Inside cPanel:

- Go to **"MySQL Databases"**.
- Create a new database.
- Create a MySQL user (or use an existing one).
- Link the user to the database and grant **all privileges**.

Save the following information:

- Database name (e.g., user\_db)
- Database user (e.g., user\_user)
- Password

**​**

**3. Upload the .sql file to the server**  
Use the **File Manager** in cPanel or an FTP client like **FileZilla**.

Upload the `.sql` file to the desired directory, for example: `/home/your_user/`

`​`

`​`

**4. Access the server via SSH**

Use a terminal (on **Linux** or **macOS**) or the **PuTTY** program (on **Windows**).

Access command:

ssh [your\_user@yourdomain.com](mailto:your_user@yourdomain.com)

**​**

**​**

**5. Import the database using the MySQL command**

Once connected via SSH, run the following command:

```
mysql --force -u username -p database_name < file.sql
```

- You will be prompted for the MySQL user’s password.
- The process may take several minutes depending on the size of the file.

**6. Verify that the import was successful**

Access **phpMyAdmin** from cPanel.

Open the database and check that the tables and data are present.