That should have been
update_option('siteurl','http://highdesertdirt.com/');
update_option('home','http://highdesertdirt.com/');
But that doesn’t matter for MultiSite as much as it might.
Scan the DB again, you may be missing something.
Thanks, fixed the theme functions URLs(my eyes aren’t what they used to be) and searched the entire DB again, but find no references to the old URL.
Then it occurred to me that the path needs to be changed too. Unfortunately, the old home dir is “center” and of course that’s a gazillion times in the DB. So I searched and replaces all instances of “center/” and “/center”, uploaded, but still get the same error. Is there a table where the home dir is references without the “/”?
Is this really EVERYTHING in the official WP support?
http://codex.wordpress.org/Moving_WordPress
Moving WordPress Multisite
Multisite is far more complicated to move, as the database itself has multiple references to the server name as well as the folder locations.
The best way to move Multisite is to move the files, edit the .htaccess and wp-config.php (if the folder name containing Multisite changed), and then manually edit the database. Search for all instances of your domain name, and change them as needed. This step cannot yet be easily automated. If you’re moving Multisite from one folder to another, you will need to make sure you edit the wp_blogs entries to change the folder name correctly.
This tutorial seems quite useful:
http://www.tutorialonweb.com/moving-wordpress-multisite-buddypress-from-local-to-live-server/
Open table ‘wp_options’ and adjust the fields ‘site_url’ and ‘home’
Open table ‘wp_options’ and adjust the fields ‘site_url’ and ‘home’
Open table ‘wp_site’ and adjust the domain and path
Open table ‘wp_sitemeta’ and adjust the field ‘site_url’
WordPress Multisite stores the standard WordPress tables for each blog with the incrementing prefix e.g. wp_1_ , wp_2_, wp_3_ … so you need to open up the ‘wp_*_options’ table for each and adjust the fields ‘site_url’ and ‘home’
In the comments the blogs table is mentioned as missed in that list and I checked all the tables and they all look ok.
However, I don’t have anything for blog one. The site only has three blogs, 1, 3 and 4. I checked the old site db and it also has nothing for blog 1. Am I missing something?
I finally re-uploaded all files and now it works. Apparently some files were missing.
Yes, that’s really everything in the codex. If you want to write up a better tutorial, please do! 😀