
Ignore those, and click the 'Export' tab on the top set of tabs. The next screen will show you all the tables inside your WordPress database.(Your screen may look slightly different, depending on the version.) Now click the name of your database - or your WordPress database if you have several databases.From the main login screen, select 'Databases' (You may not need to do this step).Information below has been tried and tested using phpMyAdmin versions 2.5.3, 2.5.7-pl1, and 2.6.1-pl3 running on Unix.ĭetailed options are listed below, though in most cases you will be fine with the default export options. Using phpMyAdmin phpMyAdmin is the name of the program used to manipulate your database. If you change the password, make the corresponding change in the wp-config.php file.

If you are uploading to a new host, you will need to recreate the database user along with the matching password. Once the upload is complete, the bottom of the browser will indicate dump complete. Using the same cPanel program, browse to the gz file and upload it. There is no need to unzip this file to restore it. A *.gz file will be downloaded to your local drive.

Look for 'Download a MySQL Database Backup' and click the name of the database.
#Querious mac full#
Do not generate a full backup, as these are strictly for archival purposes and cannot be restored via cPanel. The backup feature can be used to backup your MySql database. Backup using cPanel X cPanel is a popular control panel used by many web host.
