This is the step that could cause some concern if you haven’t used phpMyAdmin before. You can get away with just doing the above steps and get a decent backup, but that’s not “Bulletproof,” and that’s what we do here: bulletproof backups.
Note: phpMyAdmin is not a place to be poking around if you’re not familiar with it. This is truly looking behind the wizard’s curtain. Do the simple steps below and don’t bother with anything else. This is a super powerful tool and one that can be very helpful but also pretty harmful if something is done wrong. Yes, we’ve taken down a number of sites in the early years just by simply misplacing a semi-colon. But you’re not messing with anything that can bring you down here, just follow below.
Log into your phpMyAdmin, probably through your cPanel. You’ll find something like the 1st image on the right. You will have the list of all the databases in your hosting package listed here. If you have more than one site, you’ll see them all listed here and you’ll get to do this for each one. Yay, you! Click on the database that you want to backup and it will expand down like in the 2nd image on the right. You’ll also see that database listed on the top.
Once there, click the “Export” tab and you’ll be at the Export page. You don’t need to change any of the defaults, just click “Go” and save it to your newly dated directory (or whatever your system is). It will most likely be something like “yoursitedb.sql”. If you’ve heard the term “SQL (Sequel) Database” before, now you have one of your own!