how to set up the SQL code for multisites?
-
Hi, I am trying to figure out how to modify the SQL code for the database of a multisite domain, with lots of sub-domains.
As my understanding, after changing the path, I will need to do followings.
UPDATE XX_posts
SET guid = REPLACE (guid, ‘http://www.old-website.com’, ‘http://www.new-website.com’);
WHERE post_type = ‘attachment’UPDATE XX_posts
SET post_content = REPLACE (post_content, ‘http://www.old-website.com/wp-content/uploads’,’ http://www.new-website.com/wp-content/uploads);————-
But, how do I do this for an WPMU site?I have checked the database, it seems all original upload-path is not stored at /wp-content/uploads/, hence, not in the wp_x_options in the database.
Is there anyone could help me to sort this out, please?
The topic ‘how to set up the SQL code for multisites?’ is closed to new replies.