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.

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.

Updated on: 21/10/2024