How to create and restore MySQL Database backup using Backup Wizard in cPanel?

# Backup MySQL Database using Backup Wizard

  • Log in to your cPanel account.
  • Navigate to the Files tab and click on Backup Wizard.
  • On the next page, select the Back Up option as you want to create a backup.
  • In the second step, it’ll ask you to select the backup type. Click over the MySQL Databases option as you want to create a separate backup for your MySQL files.
  • At the final step, you’ll see a list of MySQL Databases present inside your cPanel. Simply click over the database you want to download and it’ll start downloading automatically.

# Restore MySQL Databases using Backup Wizard in cPanel 

  • Log in to your cPanel account.
  • Navigate to the Backup Wizard section.
  • Now, click over the Restore option instead of Back Up as you want to restore the MySQL backup.
  • Select the Restore type. There are three options that are Home Directory, MySQL Databases, Emails & Filters. You can choose the option according to your restoration type. For example, click the MySQL Databases button to restore the databases.
  • In the final step, browse the MySQL database using Choose File button.
  • Select the database file and then click over Upload.
  • A confirmation message will appear.
    Determined database name from sql
    Restoring database “getintod_wp720”
    Done!

 You can also refer to the blog to learn about the detailed procedure.

  • adding user to database, create desired mysql backup, backup database using backup wizard, add mysql user to database, mysql partial backup, restore backups from cpanel, restore backups using backup wizard, how to add user in database from cpanel, restore mysql backup using backup wizard in cpanel, restore mysql database, mysql database backup and restore, backup mysql database, restore mysql backup, configure mysql database, create mysql backup partially, backup mysql database using backup wizard in cPanel, backup database from cPanel, create specific backup
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Install WordPress in Sub-Directory?

Login to cPanel. Select Softaculous Apps Installer from Software section. Select WordPress...

How to Restore Backups Using JetBackup 4 in cPanel?

Login to cPanel and get inside JetBackups section. Here, you will find multiple features which...

How to Suspend Outgoing Emails of a cPanel Account as WHM Reseller?

To manage the bulk mailing that occurred from a cPanel account hosted within your WHM Reseller,...

How Can You Create/Install WordPress On Sub-Domains?

#1. Create a subdomain of your main domain Log into your cPanel and go to the Subdomains...

How to disallow a particular directory from being crawled by Google?

Login to your cPanel Go inside File Manager Click on public_html Create a robots.txt file....