Exporting a MySQL Database via phpMyAdmin

Locating phpMyAdmin


cPanel

    1. Login to cPanel.
    2. There will be an icon for phpMyAdmin in the Databases section.  This will take you to phpMyAdmin. 
    3. The list of available databases will be listed on the left hand side once you get into phpMyAdmin.

Local Computer

    1. Use your web browser to access http://localhost/phpmyadmin or http://127.0.0.1./phpmyadmin

Exporting a Database
  1. Go to an existing database in phpMyAdmin.
  2. Click Export at the top.
  3. Leave the settings as they are, click the "Save as file" checkbox and click Go.
  4. This will download a .sql file to your computer.
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How do I Create/Delete a MySQL Database in cPanel?

Create a MySQL Database Log into cPanel. Under Databases, click MySQL Databases. In the New...

How do I Create or Delete a Database User

After creating the database, you will need to create a user and assign privileges. Please note...

How do I Assign/unassign Privileges to Database User

Assign Privileges to Database User Log into cPanel. Under Databases, click MySQL Databases....

How can I import my MySQL database in cPanel?

Go to phpMyAdmin Click the new database name in the top left (optional) Click Import in the...