Tip: Start typing in the input box for immediate search results.

< Back
Print

Export a Database – cPanel

Learn How to Export a Database in cPanel using phpMyAdmin. You may occasionally need to export a database from your web host. Possible reasons: 

  • you are transferring a MySQL database from one hosting account to another
  • you are manually performing a MySQL database backing up.

Video tutorial – Export a Database in cPanel


Step-by-step tutorial – Export a Database in cPanel

  1. Login to cPanel.

    Tutorial: login from the Client Area or the direct link.

    Find the Databases section and click the phpMyAdmin link.

    Extilum cPanel - Databases - phpMyAdmin

  2. phpMyAdmin Interface

    In the left pane of the phpMyAdmin page, click the database that you want to export.

    Extilum cPanel - Databases - phpMyAdmin

  3. Export Tab

    Click on the Export tab in the top center pane.

    Extilum cPanel - Databases - phpMyAdmin

  4. Exporting tables

    Export method
    Quick export method – download the .sql file immediately
    or
    Custom export method – gives you more control over the data.
    Format
    – Choose SQL
    Tables (Custom method only)
    – Choose Select All

    Extilum cPanel - Databases - phpMyAdmin

  5. Exporting tables

    Object creation options (Custom method only):
    – Select Add drop table/ view / procedure / function / event / trigger

    Extilum cPanel - Databases - phpMyAdmin

  6. Click the Go button to continue.

    Extilum cPanel - Databases - phpMyAdmin

  7. Save the file to your local drive.

    Extilum cPanel - Databases - phpMyAdmin

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous Import a Database – cPanel