Build Your Own Business Website header image

Solve Every Website Admin Headache with WPEngine – Part 7 – Change Site Address in Database

Difficulty Level -

Listed Under Lesson Subjects -

Applies to -

Whoops, you've found some protected content!

Watch the opening clip of this video to preview it,
the full video is available to free and paid members.

We’re still working on Migrating the site to WPEngine. We just finished importing the database and we need to make a couple of manual changes to the database tables.

Manual Changes for Database Tables

His database originally had a different than typical prefix added to it for security so it retained those wp_sdpg. We’re looking now for the options table and this is the one we need to modify here. So we click on options and we need to change siteurl and home url.

Change Names for Site URL and Home URL

Actually, I’m totally surprised to see those as items 1 and 2 because it’s usually item 1 and item 36 or something like that. Those being 1 and 2 is usually not the case. We need to edit both of these. We have to come back over to our dennistoman and again, look at our domains for this.

It’s dennistoman.wpengine.com, that is not the final domain but it is the domain that we’re putting in right now. There’s no www, it’s dennistoman.wpengine.com, that’s is the actual address and we’ll hit Go. That was siteurl now we’re going to edit home url and paste that thing in there and hit Go.

Typical Location for Site URL and Home URL

I’m going to show you what that looks like on my site. Let’s go back to BYOBWebsite. Go to the User Portal here. Let’s look at BYOBWebsite’s database and go down to the options tables. My siteurl is option id number 2 and then 33 is my option byobwebsite.com. That’s pretty typical for a WordPress install that the siteurl and the home url are separated by that many.

So siteurl is number 1 in this one and home url is number 33. I just want you to recognize that in your case, it’s not probably not going to be 1 and 2.

0 Comments… add one
0 comments… add one

Leave a Comment