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.
« Go back