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.
Login to Plesk.
Instructions on Exporting a Database
Go to an existing database in phpMyAdmin.
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.