How to import and export a database using phpMyAdmin May 13, 2023

Looking to import and export databases using phpMyAdmin? Then read this article.

Using cPanel, you can import and export databases with the help of the phpMyAdmin menu, which you can find in the database section.

Note: phpMyAdmin only allows you to import and export the database up to 1GB. If you want to import or export large databases, then you use SSH.

Steps to Import Database:

1. Log in to your “cPanel Account”.
   
2. Navigate to “Database” and click on “phpMyAdmin” sub-option.
   
3. Select the database that you want to import.
   
4. Click on the “Import”.
   
5. Choose the “.sql” file from your computer and click on the “Go” button.
   
6. Once your database has been successfully imported, you will get a notification.
   

Steps to Export Database:

1. Log in to your “cPanel Account”
   
2. Navigate to “Database” and click on “phpMyAdmin”.
   
3. Select the database which you want to export.
   
4. Click on the “Export”.
   
   
5. Select the required file from the menu in “Format” and click the “Go” button:
   

That is it! In this way, you can import and export a database using phpMyAdmin.