Export MySQL databases using phpMyAdmin in cPanel

Written by Shai Ben-Naphtali Sunday, 15 November 2009

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

• 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

• Now you can make sure of 4 things and download your backup of your database to your PC (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.

3 Comments

1. Joe   |  Wednesday, 24 August 2011 at 9:53 am

   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. Arvand Sabetian   |  Tuesday, 30 August 2011 at 10:50 am

   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.

   
3. Gewichtsreduktion Hypnosecoaching Frankfurt a.M. effektiv   |  Thursday, 02 August 2012 at 12:35 pm

   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