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.
- 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.
For more articles on the topic of Databases, please visit our Knowledge Base.
