Export MySQL databases using phpMyAdmin in cPanel
Written by Shai Ben-Naphtali Sunday, 15 November 2009
 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)
- 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)
- Now you can make sure of 4 things and download your backup of your database to your PC (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.