Snapcreek

Snap Creek Software

Common Sense WordPress Solutions

How to Import or Export a Database using cPanel

You may occasionally need to export a database from or import a database to your web host. The following procedures explain how to achieve each of these using the phpMyAdmin web application.

How to Export a Database using cPanel

The following procedure explains how to export a database using the phpMyAdmin cPanel component:

  1. Login to your host’s cPanel interface (or equivalent).
  2. Click on the phpMyAdmin icon.
  3. On the left side of the screen, select the database you wish to export.
  4. Click the Export tab.
  5. If you want to export the entire database, select the Quick export method, otherwise click Custom and select the tables you wish to export.
  6. Set Format to SQL
  7. Click Go.
  8. Save the file to your local drive.

You now have a dump of the database in SQL format that is appropriate for future import.

How to Import Data into a Database using cPanel

The following procedure explains how to import data into a database using the phpMyAdmin cPanel component:

  1. Create a SQL file by either exporting the data as explained above or from a third party source.
  2. If your SQL file is over 2MB in size and is not compressed, compress it using zip.
  3. If you don’t have a database or if you already have a database and want the existing tables removed see this article for how to create a database or remove tables.
  4. Login to your host’s cPanel interface (or equivalent).
  5. Click on the phpMyAdmin icon.
  6. Click on the Import tab.
  7. Click on the Choose File button and select the compressed SQL file.
  8. Ensure SQL is chosen as the format.
  9. Click Go.

Your data has now been inserted into the database.

Scroll to top