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. 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ĬPanel is a popular control panel used by many web hosts. For whole WordPress site backup, refer WordPress Backups. NOTE: Below steps backup core WordPress database that include all your posts, pages and comments, but DO NOT backup the files and folders such as images, theme files on the server. Restoring your database from backup is then possible if something goes wrong. It is strongly recommended that you backup your database at regular intervals and before an upgrade.

Navicat on ubuntu