How to Import/Export a mySQL database using cPanel & phpMyAdmin
This article will guide you how to use cPanel and phpAdmin to import and export your MySQL database. However, this tutorial assumes that you have already created a database. If you haven’t done so, you’ll need to do so first.
Import
To import a database into an existing database (.sql file) in cPanel using phpmyadmin follow the steps below.
- Log into your cPanel account
- Locate the “phpMyAdmin” icon found under the “Databases” section
- After phpMyAdmin loads, click on the “Import” tab.
- Click on the “Choose File” button and select your .SQL file.
- 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.
- Log into your cPanel account
- Locate and click on the “phpMyAdmin” icon under the “Databases” category
- Once phpMyAdmin loads, select a database from the left that you wish to export from the list on the left
- Click on the “Export” tab and select an export option (see below for export options)
- 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.
