Exporting a MySQL Database via phpMyAdmin
How Can I Export a Database?
Similar to Importing Databases, there are many ways on how you can export your MySQL databases. This article will discuss instructions for exporting a database, also known as a database dump.
Jump to a Section:
- Video Tutorial ⤵
- Finding phpMyAdmin in your Control Panel ⤵
- Instructions on Exporting a Database
- Notes and Concepts ⤵
This video shows how to export data from your MySQL database using phpMyAdmin. A link to phpMyAdmin can be found in your HostGator control panel (cPanel or Plesk depending on your hosting package).
The directions in the video may differ slightly from the directions listed below. Additional directions not found in the video on how to get to phpMyAdmin for cPanel and Plesk users are also listed below.
Finding phpMyAdmin in your Control Panel
Once you have created a database, you can access it via the web administration panel.
- Log in to cPanel.
- Under the Databases section, click phpMyAdmin.
- A list of available databases will be displayed once you expand the username on the top left-hand side of the phpMyAdmin homepage.
- Log in to Plesk.
- Click on Website & Domains from the left-hand menu.
- Click on Databases in the list of functions.
- Locate the database you wish to access.
- Click on phpMyAdmin.
- You will then see a list of available databases in your control panel.
Exporting Databases via phpMyAdmin
- Select an existing database in phpMyAdmin.
- Click the Export tab on the top menu.
- The Quick radio button is selected by default.
- Scroll down and click Go.
- This will download a .sql file to your computer. Depending on the database’s size, the downloading may take some time.
More in-depth instructions, including explanations of different options on the export screen, can be found in the video above.
Exporting Databases via cPanel’s Backup
Alternatively, you can also use the Backup feature of your cPanel as demonstrated in the video guide above.
- Log in to the cPanel.
- Under the Files section, click Backup.
- Scroll down the Backup page and locate Download a MySQL Database Backup.
- Click the database name you wish to generate a backup for.
Notes and Concepts
For the video tutorial, we are connected to phpMyAdmin using the root MySQL user. When connecting as another user, some options may be disabled, depending on the server's configuration and the specific privileges granted to the user by the system administrator.
On systems with Plesk, the master MySQL user is the admin user instead of root.
Many systems, like HostGator's servers, are configured with control panel software installed used to delegate the administration of the account on the server. Whenever possible, it is recommended you use the controls within the control panel itself for certain tasks (such as the creation of databases, creation of users, management of user privileges, etc.) instead of phpMyAdmin. Performing these tasks outside the control panel without full knowledge on how to work around them can produce undesirable results in the operation of the control panel software.
Please note that on Linux-based systems, database names, database users, table names and column names are case sensitive, whereas on Windows-based systems they are case insensitive.