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, ‘https://www.old-website.com’, ‘https://www.new-website.com’);
WHERE post_type = ‘attachment’UPDATE XX_posts
SET post_content = REPLACE (post_content, ‘https://www.old-website.com/wp-content/uploads’,’ https://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.