Knowledgebase
NetworkPanda > Client and Support Area > Knowledgebase

Ask a question:


WordPress: How to backup your database

Solution

Below steps backup core WordPress database that include all your posts, pages and comments. Backup using cPanel The cPanel backup feature can be used to backup your MySQL database. 

Backup using cPanel

Log into cPanel, click 'Backups' and look for 'Download a MySQL Database Backup' and click the name of the database. A *.gz file will be downloaded to your local drive. There is no need to unzip this file to restore it. 

Using the same cPanel program, browse to the gz file and upload it. Once the upload is complete, the bottom of the browser will indicate dump complete. If you are uploading to our server, you will need to recreate the database user along with the matching password. If you change the MySQL username or password, make the corresponding change in the wp-config.php file. 

Backup using phpMyAdmin 

Log into phpMyAdmin on your server 

From left side window, select your WordPress database. 

The right side window will show you all the tables inside your WordPress database. 

Click the 'Export' tab on the top set of tabs. 

Ensure that the Quick option is selected, and click 'Go' and you should be prompted for a file to download. Save the file to your computer. Depending on the database size, this may take a few moments.

Article details
Article ID: 4094
Category: Wordpress
Date added: 2016-12-24 04:17:53
Views: 9

 
« Go back

NetworkPanda Billing & Support - NetworkPanda 2002-2017