Database Question Regarding Wordpress

4 replies
My question is.. should I have 1 blog per database or is it ok to add more than 1 blog inside a database..

In other words, could several wordpress blogs share 1 database without causing problems?

Thanks!
#database #question #wordpress
  • Profile picture of the author DarkLour
    yes they can. usually using cpanel auto install or such will add a few letters before the tables like wp1_thetablename and when you install another wp2_thetablename

    if you install it by hand it will ask if you want a "prefix" thats the wp1_ part
    so with that its easy to have multiple blogs in one db with no problems
    Signature

    Best Regards,
    James
    Culinary Website Design : Cooking Blog :

    {{ DiscussionBoard.errors[1525416].message }}
    • Profile picture of the author Victoria Gates
      Originally Posted by DarkLour View Post

      yes they can. usually using cpanel auto install or such will add a few letters before the tables like wp1_thetablename and when you install another wp2_thetablename

      if you install it by hand it will ask if you want a "prefix" thats the wp1_ part
      so with that its easy to have multiple blogs in one db with no problems
      Appreciate your response!
      Signature
      Victoria Gates - Digital Marketing Specialist

      {{ DiscussionBoard.errors[1525518].message }}
  • Profile picture of the author pjCheviot
    Banned
    Hi Victoria

    There is certainly no problem with using one database with various table prefixes as DarkLour suggests, and if your hosting only allows one MySQL database then that is the way to do it, however . . . ..

    if you are ever thinking of flipping or selling any of those sites, then extracting the necessary data is more of a problem then. So if your hosting allows multiple MySQL databases then using one per blog would possibly be better.

    Just a thought . . . .
    {{ DiscussionBoard.errors[1525609].message }}
  • Profile picture of the author Victoria Gates
    Thanks, I did not plan to flip these blogs, but it's good to know.
    Signature
    Victoria Gates - Digital Marketing Specialist

    {{ DiscussionBoard.errors[1525683].message }}

Trending Topics