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!

    • Under MySQL Databases, go ahead and create a username and password for your database, you should now see a “Browse Database” option inside WebSitePanel. That will take you to phpmyadmin which will provide you with the same options as the one on the cpanel side to export and then re-import on the linux side.

  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 *


× 2 = 18

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>