All Collections
Useful Tools and Tips
How to Import and Export a MySQL Database Using phpMyAdmin
How to Import and Export a MySQL Database Using phpMyAdmin
Scott avatar
Written by Scott
Updated over a week ago

Overview

This article will discuss how to import a MySQL database backup file as well as how to export a copy of your MySQL database. These are useful tasks when wanting to make personal backups of your websites and/or applications, and for importing backups from other servers.

 

Importing a MySQL Database Using phpMyAdmin:

1. Begin by accessing the cPanel account you’re wanting to import the database to. Please review the article on accessing your cPanel account if you have any trouble.
2. From within cPanel, scroll down to and select phpMyAdmin.

3. From within phpMyAdmin, select the database name under the username which you will be importing the backup to.

4. Select Import along the horizontal menu.

5. Browse to your local MySQL backup file. In most cases, all other settings can be left as default.

6. Confirm the proper file was selected and finalize the MySQL import by selecting Go!

 

Exporting a MySQL Database Using phpMyAdmin:

1. Begin by accessing the cPanel account you’re wanting to export the database from. Please review the article on accessing your cPanel account if you have any trouble.
2. From within cPanel, scroll down to and select phpMyAdmin.

3. From within phpMyAdmin, select the database name under the username which you will be exporting the backup from.

4. Select Export along the horizontal menu.

5. Now, select the Quick exporting method, making sure the format is set to SQL

6. Finalize the Export by selecting Go and saving the file locally.

 

These operations can also be completed with significantly more flexibility through the command line, however those commands are outside the scope of this article. If you are having any trouble importing or exporting a MySQL database please never hesitate to contact BigScoots. We’re always ready and waiting to assist in anyway we can! 

Did this answer your question?