Changing DOMAIN_CURRENT_SITE from IP to URL

No, that’s kinda it, though I have this memory that Ron said something about how you could goober your options tables doing that. Darn it, where’s WPMUGuru when you need him?

Yes, if the the URL (or IP Address in this case) is stored in a PHP serialized array, then you’ll mess up your options table when you do a find/replace.

You can use something like https://spectacu.la/search-and-replace-for-wordpress-databases/ to do it in a safe way. I use this script successfully very often, but I have heard it won’t work for some people.

Does that plugin work for the database as a whole or just on a per site basis? Does that make sense?

What Tim said. ?? There’s a few others out there too. Otto has another link, I keep forgetting to copy it in my file. ??

my bad. I just realized it isn’t actually a plugin…

I’ll give it a shot. Thanks for the help.

Ok, I tried it out and unfortunately I got a “cannot connect to the database” error once I ran the “search and replace database” tool, and changed the current_site info in wp_config.

Any other suggestions?

Did you edit the script and give it the database info? It needs the same info as you have in wp-config.php.

Got phpmyadmin? you can do it from there. Or get a db dump and do it in there.

@ Tim — yeah, the script worked. It just gave the site a Database Connection error. Not sure what the problem was.

@ Andrea, yeah I’ll try the DB dump. That’s what I was originally planning, but Tim mentioned messing up the options table with a find/replace. With an IP address, it should be a pretty clean to replace that with an URL, no?

With an IP address, it should be a pretty clean to replace that with an URL, no?

No, unless the domain has the exact same number of characters as the IP address.

And that’s only if the IP is in any stored arrays in the db. Sometimes I just do those ones manually, one by one.

hmmm. It should be easier shouldn’t it…

Is this not more or less what I’m attempting?:
https://www.ads-software.com/support/topic/changing-base-url-of-30-multisite-installation?replies=6

Again, thanks for your time.

It shoudl but it isn’t due to the fact the URL is stored in multiple tables across multiple fields in the entire db. Find ’em. replace ’em.

So, I download the db, did a search-and-replace, and imported… and it worked!

The only thing that didn’t make it was some images in a slideshow plugin, but that’s pretty minor stuff.

Thanks for your input! Much appreciated.