This is the second in a short series on cloning your WordPress website and installing it on another domain. This can be useful when moving a site from a development server to its final live location. In this lesson we will make a copy of the source database using phpMyAdmin. The host in this example is Bluehost and the control panel is cPanel.
Rick: So then step 2 is make a copy of your database. And so, we are going to over to… and Cathy, make sure you raise your hand or type a question in or whatever, as we’re going through this. If you have any questions…in fact, I see you’ve got your hand raised so I’m going to unmute your microphone. Are you with us, Cathy?
Cathy: Yes I am. So far, so good.
Rick: Okay, you’re comfortable with what we’ve done so far?
Cathy: Yes I am. Thank you.
Rick: Okay, perfect. You betcha. So the next thing to do then is to copy this database and I’m going to do that in phpmyAdmin. Sometimes, it’s a little slower to load up here. In fact, it’d even ask you to be patient. I love it when a machine asks you to be patient.
Okay so let’s see, if I can remember this password… good, I did. No, I didn’t. Let’s try my new password. Maybe that is it. Yeah, I wish the host didn’t require me to log in to both things but… okay so here I am on my phpmyAdmin and you can see I have a whole bunch of databases here. And now that I say that, I don’t know which database I want. I don’t know which database I want. Oh no, emember 4, that’s right. So emember 4 is the database I’m going to copy so I select it here on the left and then I go to export. And I can leave all these things as they are by default and just scroll down and grab the gzipped version of the database and say go. And what it does is it automatically zips it up and then downloads it. I’m going to save it and I’m going to hope that… oh, perfect. I’m just going to save it to my desktop.
Okay so, I have now saved this database, byobwebs_emember4 and now what I’m going to do is create a new database.