Knowledgebase: cPanel Functions
Exporting a MySQL Database via phpMyAdmin
Posted by John Roberts, Last modified by Nick Tyree on 12 October 2015 12:40 PM

Finding phpMyAdmin in your Control Panel

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.

Instructions on Exporting a Database

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.
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 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.

Help Desk Software by Kayako