Export MySQL databases using phpMyAdmin in cPanel

Related documents:
[1] Import MySQL databases using phpMyAdmin in cPanel

Using phpMyAdmin to export your databases is very simple.
We suggest you use this to do regular backups every once in a while (decide on your own backup scheme) and/or before doing an upgrade or change to your database.

Lets read more on how you can accomplish this.

  • Go into your cPanel (your control panel) and find the Databases section -> phpMyAdmin icon (picture 1)

    picture1

    picture1

  • Now in phpMyadmin, you’ll see on the left the list of databases and a link called Export in the main page. Click Export (picture2)

    picture2

    picture2

  • Now you can make sure of 4 things and download your backup of your database to your PC (picture3)
    picture3

    picture3

    Note:  If “zipped” doesn’t work, then use “gzipped”.

  • Now just choose to save it on your PC and there you go, you have a MySQL Dump file (backup) on your PC.
Tags: , , , | Posted under cPanel/Linux Hosting, MySQL, phpMyAdmin | RSS 2.0

4 Comments on Export MySQL databases using phpMyAdmin in cPanel

  1. Joe says:

    OK so I have Personal Class ASP, and it has WebSitePanel Control Panel instead of CPanel.

    I know how to run the SQL script to recreate it with CPanel, but I have no idea how to do this with WebSitePanel Control Panel

    help!

  2. That is really attention-grabbing, You are an excessively
    skilled blogger. I’ve joined your feed and look forward to searching for more of your excellent post. Also, I have shared your site in my social networks

  3. wine dine says:

    Thanks for the steps on exporting! Cheers!

Leave a Reply

Your email address will not be published. Required fields are marked *