Import/Export Database

Help Center

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.



Import Database


Step 1

Log into your cPanel Account.



Cpanel Login Screen



Step 2

Scroll down to * Databases * section and click on * phpMyAdmin* icon.



cPanel Databases



Step 3

Select the database from the left panel that you would like to import.



phpMyAdmin Database


Step 4

In the top menu, select * Import *



phpMyAdmin Database Import


Step 5

Click Browse and locate the .sql file from your computer. When finished, click * Done * at the bottom.



phpMyAdmin Database Browse


Step 6

You will now see a message that the Database was successfully imported.






Export Database





Step 1

In cPanel, scroll down to * Databases * section and click on * phpMyAdmin* icon.



cPanel Databases



Step 2

Select the database from the left panel that you would like to export.



phpMyAdmin Database



Step 3

Click the * Export * tab at the top menu and select the Format with the drop-down menu.



phpMyAdmin Database Export



Step 4

Press * Go * and you will now be able to save the Database.






That is all !