This is third part of How to Upgrade Your WordPress Website – A Best Practices Demonstration Tutorial Series. In this session, we perform a manual backup of the database, we determine which databases are we going to backup and use the phpMyAdmin to back it up.
The next thing to do is to make a manual backup of my database. Now, as you’ll see here in a moment, I don’t necessarily know what database is associated with this WordPress installation. So I’m going to go find that out. If you’ve only got one WordPress installation, only one WordPress database and it’s no big deal. But if you have multiple installations of WordPress on your account, you’ll see that your… that you may have a whole bunch of different databases as well. And those databases aren’t necessarily named in a way that’s easy for you to figure out.
So for example, we’ll go over here to php myAdmin because this is the tool that we’re going to use to back the database up. And you can see that I have a whole bunch of different databases here, in this installation. And I can’t tell which one of the databases it is that I’m using here so I need to go find that out. And I’m going to find that out by looking at my php… I’m sorry… by looking at wpconfig.php.
So I use my file manager and I’ll go to public html. And I’ll scroll down here which is where that site is installed. I’ll come down to wpconfig.php and I’m going to select the code editor. Say edit and what you’ll see here is the 2nd… well actually, I guess it’s the first one. The database name here is byobtuto_word30. So this is the database I’m looking for which is right here, word30.
Okay and the way to back this up is simply to export it. Come over to export. I can use a quick export method for this. I don’t need a custom export. I want to export it as an SQL file and so all I have to do here is say go. And my database has been both exported and downloaded to my computer, right down here.
Okay so now we have that next step done. We’ve done a manual backup of the database.