Database Question Regarding Wordpress

by 4 replies
5
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!
#programming #database #question #wordpress
  • 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
    • [ 1 ] Thanks
    • [1] reply
  • 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 . . . .
    • [ 1 ] Thanks
  • Thanks, I did not plan to flip these blogs, but it's good to know.
    • [ 1 ] Thanks

Next Topics on Trending Feed