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.