Casbay Knowledge Base

Search our articles or browse by category below

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

Last modified: October 1, 2022
You are here:
Estimated reading time: 1 min

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

Was this article helpful?
Dislike 0
Previous: Why is connection MySQL error?
Next: Tweak MySQL using MySQLTuner