A) I would, but I'm not allowed to mess with the server I'm working on (I often do most of my WP work for another design firm; plus I have no idea what that would do to other sites on the test server, I've never done that before and wouldn't know where to begin).
B) I usually do this, but it doesn't retain the serialized data, so Text widgets are completely gone
C) Same issue as mentioned above. To quote from that post:
"Choose the tables to search" - again, that's what I was trying to resolve :)
1652 queries. Over 100 tables.. waaayy time consuming, just seems so inefficient. Someone with knowledge of MySQL probably has an answer that's simple, but I have no idea where to begin. I've searched all over the internet, there's really no info out there (least not in a language I could understand). I'm just looking for a simple query that would be like:
find 22.214.171.124 and replace it with http://mywebsite.com but NOT having to search and select all the tables where that IP address is, just search the entire database and change it.
That tool I mentioned above does that very well, except the text widgets are gone, so that's the only problem.
Thanks anyway though. I'll keep researching, otherwise the client is going to have a helluva time adding all her content back for all those text widgets in all 107 websites in her network tomorrow. yuk!