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:

Log in to cPanel
Scroll down to the "Databases" section, then click phpMyAdmin.
Select the Database
On the left sidebar, click the name of the database where you want to import data.
Click 'Import'
In the right window, navigate to the 'Import' tab at the top of the screen.
Click 'Choose File'
A window will open where you can browse your local device.
Select the SQL File
Find and select the .sql file you want to import.
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:

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

Updated on: 21/10/2024