- Login to your cPanel.
- Under the files section, click on Backup.
- Under Restore a MySQL Database, click on Choose File.Next navigate in the file browser to your database backup you’d like to restore, click on it, then click on Open.
- You should now see your database backup that you’ve selected, go ahead and click Upload.
- Finally you’ll see the full backup that got restored, notice how it mentions our userna5_wordpress database already existed, and also it’s using the DROP TABLE IF EXISTS command.