Title: Database differences between Single and Multisite installation
Last modified: August 20, 2016

---

# Database differences between Single and Multisite installation

 *  Resolved [shadez](https://wordpress.org/support/users/shadez/)
 * (@shadez)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/)
 * Hi,
    I wanted to know if any new entries/tables/etc are created automatically
   while upgrading a single WP installation to Multisite?
 * Reason: i just upgraded my website to multisite, only to realize later on that
   i am running on shared server and hence cant use subdomains! yeah dumb me for
   not remembering it then!
    Now all my posts have gone corrupt post upgrade and
   has some unicodes(i guess) like ‘Â’ and ‘‒ in all of them! 🙁 you can see for
   yourselves at [http://www.iamabiker.com](http://www.iamabiker.com) i wish to 
   rollback my DB(backup taken prior upgrade) asap. but am skeptical in updating
   the MS DB with a Non-MS one.
 * Thanks…

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Thread Starter [shadez](https://wordpress.org/support/users/shadez/)
 * (@shadez)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/#post-3063503)
 * ok so i found this:
    [http://wpmututorials.com/how-to/how-to-disable-multisite/](http://wpmututorials.com/how-to/how-to-disable-multisite/)
 * a derivation of it would mean that the following are the new tables added:
    wp_blogs
   wp_blog_versions wp_registration_log wp_signups wp_site wp_sitemeta
 * so… there are ‘NO’ other changes/new-entries in DB???
 * like i said, i dont want to rollback my multisite installation. just update the
   DB to previous single-site one.
 * could somebody pls help confirm?
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/#post-3063591)
 * Those directions are correct.
 * The only addition to those tables are if you added a subsite (then you’d have
   wp_2_posts etc etc)
 *  [ancawonka](https://wordpress.org/support/users/ancawonka/)
 * (@ancawonka)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/#post-3063596)
 * You can turn off multisite by restoring the database to a previous version, but
   you should also clean up the .htaccess file. You’ll get database errors otherwise.
 *  Thread Starter [shadez](https://wordpress.org/support/users/shadez/)
 * (@shadez)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/#post-3063612)
 * thanks ladies.
    strangely, reverting back htaccess and wp-config itself solved
   my problem of data corruption. and only other thing added extra into wp-config
   were these for security:
 * [deleted]
 * and yeah, thanks Mika for your books on WPMS. downloaded from halfelf.org and
   going thru it now…
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/#post-3063615)
 * Those are your Secret keys: [https://api.wordpress.org/secret-key/1.1/salt/](https://api.wordpress.org/secret-key/1.1/salt/)
 * SECRET is the key word 😉 Don’t share ’em. And yes, you should always have them.
   They make logging in more secure.
 *  Thread Starter [shadez](https://wordpress.org/support/users/shadez/)
 * (@shadez)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/#post-3063619)
 * yikes! didnt know that. thanks again.. 🙂

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Database differences between Single and Multisite installation’ is closed
to new replies.

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 6 replies
 * 3 participants
 * Last reply from: [shadez](https://wordpress.org/support/users/shadez/)
 * Last activity: [13 years, 8 months ago](https://wordpress.org/support/topic/database-differences-between-single-and-multisite-installation/#post-3063619)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics