How to Import and Export a Database with phpMyAdmin
With cPanel, you could import and export databases with phpMyAdmin.
This guide will show you step-by-step instructions on importing and exporting databases with cPanel in the Database section.
Please be aware that databases over 50MB need to be imported via SSH.
Log into your cPanel Account.
Scroll down to * Databases * section and click on * phpMyAdmin* icon.
Select the database from the left panel that you would like to import.
In the top menu, select * Import *
Click Browse and locate the .sql file from your computer. When finished, click * Done * at the bottom.
You will now see a message that the Database was successfully imported.
In cPanel, scroll down to * Databases * section and click on * phpMyAdmin* icon.
Select the database from the left panel that you would like to export.
Click the * Export * tab at the top menu and select the Format with the drop-down menu.
Press * Go * and you will now be able to save the Database.
That is all !