Title: Multi site content changing
Last modified: April 6, 2018

---

# Multi site content changing

 *  [muprabakaran](https://wordpress.org/support/users/muprabakaran/)
 * (@muprabakaran)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/multi-site-content-changing/)
 * Hi,
    I’m facing issues my wordpress multi site network, we having three site 
   1. [http://opheila.com/](http://opheila.com/) 2. [http://opheila.com/us/](http://opheila.com/us/)
   3. [http://opheila.com/in](http://opheila.com/in) we need to deleted the [http://opheila.com](http://opheila.com)
   website content and [http://opheila.com/us](http://opheila.com/us) content move
   to [http://opheila.com](http://opheila.com)
 * how to achieve this functionality work.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmulti-site-content-changing%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [8 years ago](https://wordpress.org/support/topic/multi-site-content-changing/#post-10202321)
 * Sorry for a late reply. Are you still looking for a way to do this or have you
   figured it out? On the chance you still need help…
 * I would first make a complete DB backup because my following plan is untested.
   Get into phpMyAdmin. You will see there are a number of tables of whose basename
   each site has in common, only the number after the prefix is different. Drop 
   all tables that are lacking a number after the prefix whose basenames are common
   to all sites. Retain tables unique to the network root like wp_users, wp_blogs,
   etc.
 * Determine which tables belong to the “/us/” site and rename them, eliminating
   the prefix number, so that the tables take on the names of the tables you just
   dropped.
 * Install the Interconnect/IT [DB search and replace tool](https://interconnectit.com/products/search-and-replace-for-wordpress-databases/).
   Use the tool to search renamed wp_posts, wp_postmeta, wp_options for URLs containing
   the “/us/” URL term and replace with a version without. I.E. search for “opheila.
   com/us/” and replace with “opheila.com/”
 * Remove the /us/ site record from wp_blogs. Note the blog ID. In wp_usermeta, 
   find meta_keys starting with the old /us/ blog table prefix and replace them 
   with the new table prefix. Find any of the old blog ID as meta_value, whose key
   is primary_blog, and change the value to the new blog ID (probably 1)

Viewing 1 replies (of 1 total)

The topic ‘Multi site content changing’ is closed to new replies.

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 1 reply
 * 2 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/multi-site-content-changing/#post-10202321)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics