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 8 years, 5 months ago by ketanco.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    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

    (@ketanco)

    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)

    (@sterndata)

    Volunteer Forum Moderator

    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.