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.