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?¨C Export the entire database using the default options.
- Custom?¨C 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.?