Following on from last week’s post which went into detail about how to backup your WordPress site, and specifically the content, this week we look at how to backup the database on your WordPress site. This is equally important and significantly quicker, so let’s dive in.
Firstly you need to login to your cpanel. In many instances the url you’ll need to use to access the cpanel will be your site domain followed by /cpanel, e.g. www.digitaldavidson.co.uk/cpanel, from there you’ll need to log in with your ftp details. The domain to access your cpanel will not always look like this, it depends who’s hosting your site, so speak to your host if you’re not sure.
Once you’ve logged into the cpanel you need to scroll down the page to find the Databases section – from there you choose phpMyAdmin.
It’s likely you’ll be asked to login again to access phpMyAdmin. Once you’re in you need to click on the database of the left hand side of the screen, it should obvious which one to click on, it’ll be the username you logged in with earlier, followed by an _db
After clicking on it the page will load to show all the database tables associated with your WordPress site. You simply need to choose the Export option on the top menu, leave it as the default Export Method and Format, i.e. Quick and SQL, and then hit the Go button.
You’ll then be asked to save the file and I’d suggest you save it to the same folder you copied across the content files as discussed in part 1 last week.
And that’s all there is to it.
If you have any thoughts about how to backup your WordPress site then here’s the place to share them. Otherwise, happy backing up. You know it makes sense.