How to Import and Export a MySQL Database in cPanel

In this article, we will provide you with step-by-step instructions for importing and exporting your MySQL database using cPanel and phpMyAdmin. Before we begin, please ensure that you have already created a database. If you haven’t done so yet, you’ll need to create one first.

Follow the steps below to import an existing database (.sql file) into cPanel using phpMyAdmin.

1. Log into your cPanel account.
   
2. Scroll down to the Databases section and click on phpMyAdmin.
   
3. Select the Import tab located at the top of the page.
   
4. Click on the Choose File button and select your file.
   
5. Select your .SQL file.
   
6. Click on the import button and your MySQL database will import.

Now, follow the steps below to export an existing database (.sql file) into cPanel using phpMyAdmin.

1. Log into cPanel.
   
2. Navigate to the Databases section, then click on phpMyAdmin.
   
3. Choose the Export tab situated at the page’s top.
   
4. Choose an export option (refer to the export options below).
   
   

   Note: Export Options

   1. Quick: Export the entire database using default settings.

   2. Custom: Choose specific tables from the database for export or modify individual export settings.

5. Click on the Export button and the database export will begin.

In this way, you can import and export your MySQL database using cPanel and phpMyAdmin. For more information, visit our knowledge base section.

Protect your data! Learn How to Back Up a MySQL Database in cPanel