I generally don’t bother with plugins for this. It’s easy enough to do in cPanel, and you’re less likely to encounter software glitches that will break your backup.
1. Log into cPanel
The address is given to you by your web host when you sign up for hosting. The page will look something like this:
2. Go To phpMyAdmin
Scroll down to the Databases section and then click the phpMyAdmin icon
3. Find Your Database
Look to the left and you’ll see your username, with a plus sign to the left of it. Click that plus sign.
Clicking the plus sign expands the list and shows you any databases listed there (you probably will only have 1 or 2). When you click your database name, you’ll see a list of stuff appear under it on the left, and a bunch of stuff appear on the right.
4. Click the Export link
Top of the page.
5. Click the Custom button
6. Select the Add CREATE DATABASE / USE statement
Scroll down the page to the Object creation options section
Then you’ll see Add CREATE DATABASE / USE statement
Click that check box.
7. Click the Go button
Scroll down the page and you’ll see it
Now the file will download to your computer. Just remember where the download is in case you need the backup file. And do not update WordPress until the backup is completely downloaded.