Title: multiple sites in 1 database
Last modified: October 3, 2016

---

# multiple sites in 1 database

 *  [ketanco](https://wordpress.org/support/users/ketanco/)
 * (@ketanco)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/multiple-sites-in-1-database/)
 * as i am running out of databases in my hosting account, and as not all my sites
   are or will be so big, i decided to put in more than 1 site in my future databases.
 * 1) how many sites can fit into one database, if you assume one site will have
   max 50 posts per year? just approximately
 * 2) i want to do labeling right… how do i label sites when installing first time
   into database? for example how do i label site1, site2 etc….
 * 3) when i have multiple sites in 1 database, is there a chance of confusion or
   mixups?
 * 4) and finally, if one of the sites in the database gets big, is it easy to extract
   that site from the database? can you describe how, just very briefly?
    -  This topic was modified 9 years, 7 months ago by [ketanco](https://wordpress.org/support/users/ketanco/).

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

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [9 years, 7 months ago](https://wordpress.org/support/topic/multiple-sites-in-1-database/#post-8249073)
 * You can put multiple sites in one database — use a meaningful prefix for each
   so you don’t oops yourself. Is it a good idea? From a security standpoint, no.
   Each site has access to the databae and can therefore affect the tables for the
   others.
 * If you want to take them apart again, you’d export the tables for the site in
   question (by prefix), and import them into a new database.
 *  Thread Starter [ketanco](https://wordpress.org/support/users/ketanco/)
 * (@ketanco)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/multiple-sites-in-1-database/#post-8249811)
 * based on roughly max 50 posts a year, how many sites can i put into one database?
 * and you said one site affect tables for the others? so there is confusion and
   mixup then
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [9 years, 7 months ago](https://wordpress.org/support/topic/multiple-sites-in-1-database/#post-8250984)
 * there is the *potential* for confusion and security issues.

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

The topic ‘multiple sites in 1 database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [9 years, 7 months ago](https://wordpress.org/support/topic/multiple-sites-in-1-database/#post-8250984)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics