Exporting a MySQL Database via phpMyAdmin
Instructions for exporting a database, also know as a database dump.
In this article:
- 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.
One you have created a database, you can access it via the web administration panel.
- Login to cPanel.
- There will be an icon for phpMyAdmin in the Databases section. This will take you to phpMyAdmin.
- The list of available databases will be listed on the left hand side once you get into phpMyAdmin.
- Login to Plesk.
- Click on the Website & Domains tab at the top.
- Click on Databases in the list of functions.
- Click on the database you wish to access.
- Click on WebAdmin in the Tools section.
- phpMyAdmin will open to the screen for administrating the database you selected.
- Go to an existing database in phpMyAdmin.
- Click Export at the top.
- Leave the settings as they are, click the "Save as file" checkbox and click Go.
- This will download a .sql file to your computer.
More in-depth instructions, including explanations of different options on the export screen, can be found in the video.
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 creation of databases, creation of users, management of user privileges, etc.) instead of phpMyAdmin. Performing these tasks outside the control panel can produce undesired results in the operation of the control panel software.
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.