Press Ctrl/Cmd + P to print
or save as PDF

HOW TO: Import / Export a mySQL database using cPanel & phpMyAdmin

This article will guide you to import and export your MySQL database using cPanel & phpAdmin. However, before you start, this tutorial assumes that you have already created a database. If you have not, you will need to do so first.

IMPORT

To import a database into an existing database (.sql file) in cPanel using phpmyadmin follow the steps below.

  1. Log into your cPanel account
  2. Locate the “phpMyAdmin” icon found under the “Databases” section
  3. After phpMyAdmin loads, click on the “Import” tab.
  4. Click on the “Choose File” button and select your .SQL file.
  5. Click on the “Go” button and your MySQL database will import.

EXPORT

To export a mySQL database, you can follow the steps below to do so.

  1. Log into your cPanel account
  2. Locate and click on the “phpMyAdmin” icon under the “Databases” category
  3. Once phpMyAdmin loads, select a database from the left that you wish to export from the list on the left
  4. Click on the “Export” tab and select an export option (see below for export options)
  5. Click on the “Go” button and the database export will begin

Export options:

  • Quick – Export the entire database using the default options.
  • Custom – Select specific tables within the database to export, or change the individual export options.

For more articles on the topic of Databases, please visit our Knowledge Base