How to Import and Export a Database with phpMyAdmin
Updated: November 21, 2020
phpMyAdmin is an essential tool when working with MySQL. phpMyAdmin allows the task of managing your MySQL databases much more easier and efficient, and it also helps you manage the available databases from just about anywhere.
Through phpMyAdmin, you're able to create, edit, back up, import, export, and also delete databases, along with managing database tables. 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.
Log into your cPanel Account.
Navigate to Databases section and click on phpMyAdmin icon.
Select the database from the left panel that you would like to import the new database into.
In the top navigation menu, select Import.
Click Browse and locate the .sql file from your computer.
Click Done. 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.