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”.

  • 147 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL from my computer

Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...

Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you receive this error message when connecting to MySQL trough command line on your VPS...

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...

How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...

Optimization and repair of MySQL database

If you have suspicions that the MySQL database is running slowly or appear errors, you need to...

Powered by WHMCompleteSolution