> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.elitehost.co.za/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).

# How can I import or export a MySQL database?

You can **IMPORT** a MySQL database using the **phpMyAdmin** tool in **cPanel** by following these steps:

### Steps to Import a MySQL Database:

1. **Log in to cPanel**
2. **Scroll down to the "Databases" section**, then click **phpMyAdmin**.
3. **Select the Database**  
   On the left sidebar, click the name of the database where you want to import data.
4. **Click 'Import'**  
   In the right window, navigate to the **'Import'** tab at the top of the screen.
5. **Click 'Choose File'**  
   A window will open where you can browse your local device.
6. **Select the SQL File**  
   Find and select the **.sql** file you want to import.
7. **Click 'Go'**  
   The import process will begin, and the selected file will be imported into the chosen database.

| The database should already be created in **cPanel -> Databases -> Manage My Databases -> Create New Database** before attempting to import.

---

You can **EXPORT** a MySQL database using the **phpMyAdmin** tool in **cPanel** by following these steps:

### Steps to Export a MySQL Database:

1. **Log in to cPanel**
2. **Scroll down to the "Databases" section**, then click **phpMyAdmin**.
3. **Select the Database**  
   On the left sidebar, click the name of the database you wish to export. This will expand the list of tables.
4. **Click 'Export'**  
   In the right window, navigate to the **'Export'** tab at the top of the screen.
5. **Choose Export Method**  
   Under **'Export Method'**, select **'Quick - display only the minimal options'**.
6. **Click 'Go'**  
   The export process will begin, and the database file will be downloaded to your device.