How to Import and Export a Database using phpMyAdmin

Looking to import and export databases using the phpMyAdmin, then read out this article.

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

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

Steps to Import database:

1. 1. Log into 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 “.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. 1. Log into 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.