Now that we have a fresh copy of your WordPress files, let’s backup your WordPress database, so we can have a full backup that will come in handy on that proverbial rainy day. Just navigate to your cPanel and locate phpMyAdmin. It’s for cPanel users users it will be located under Database Tools…
Once you log into phpMyAdmin you should see a main administration panel.
Select the Databases tab to list your databases.
Select all the tables you’d like to backup by ticking the checkboxes. Once you’ve selected the tables, click the Export tab. Select the export method, and set format to SQL:
Hit the Go button, and save your database in the same location you saved copies of your WordPress files. That’s it.
You now have a full backup of your WordPress site!