Export and import of MySQL databases from cPanel

For management on databases in your hosting account you can use the web application phpMyAdmin.

In the Control panel click the phpMyAdmin icon.

First select the database which you’ll work with by clicking on it.

Export database

Once you have selected the database, click Export from the menu.

In the opened window can make further export adjustments. You can download the database on your computer too (in the form of sql, gzip, zip file).

Import databases

Before making the import of data is necessary to create a database in which to import them. The creation of database can be done from the control panel (cPanel).

After selecting of the database by clicking on it, click Import from the menu.

You need to make sure that the exported database from your computer is in the form of sql, gzip, zip file, and then select “Go”.

  • 88 Users Found This Useful
Was this answer helpful?

Related Articles

How to delete a MySQL database in cPanel

How to delete a MySQL database in cPanel? First you need to log in to the cPanel while using...

How to create a MySQL database user in cPanel

How to create a MySQL database user in cPanel? Log in to the cPanel while using username and...

How to Manage a MySQL Database with phpMyAdmin in cPanel

How to Manage a MySQL Database with phpMyAdmin in cPanel? In order to manage a MySQL database...

How to assign a user to a MySQL database in cPanel

How to assign a user to a MySQL database in cPanel? First you need to log in to the cPanel...

Export and import MySQL databases via SSH

If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...