can two forums on one server share a db?

[cryogenikz]

im going to add another forum on my site for another category, is it possible for this new one to share databases with the original forum?

[tbonekkt]

Absolutely. Just use a different table prefix for the second forum.

[cryogenikz]

Originally posted by tbonekkt
Absolutely. Just use a different table prefix for the second forum.

can they share tables? like users, posts, etc..?

[chrism]

I may be way off here but wouldn't it be easier to just use the same forum install and just make a new section for the new topic in your already existing forum?

I think with what your wanting to do that would be the easiest way to do it.

When you install a new forum into the same database and set it to use different table prefixes then that will apply to all tables for that forum. With a lot of work you might be able to make some configuration changes so that it would use some of the same tables as the 1st fourm but I haven't tried it so it may not work.

[cryogenikz]

Originally posted by chrism
I may be way off here but wouldn't it be easier to just use the same forum install and just make a new section for the new topic in your already existing forum?

I think with what your wanting to do that would be the easiest way to do it.

When you install a new forum into the same database and set it to use different table prefixes then that will apply to all tables for that forum. With a lot of work you might be able to make some configuration changes so that it would use some of the same tables as the 1st fourm but I haven't tried it so it may not work.



i found a nice premodded version of phpbb forums with everything already installed, the works.. but i dont want to overwrite it over the older 'manually-modded' version yet because there may be errors id need to correct and i dont want my users to go through too much down time.. so id rather test it on the server, with database and all, then overwrite the older manually-modded version when im fully confident that the new pre-modded installation works 100%.

so what i want to know.. is can i test the pre-modded installation on the server with the same database, and database tables as the manually-modded version temporarily, so i can test it.. then eventually overwrite it with the newer installation?

[Trip59]

If they have identical mods, you "could" do this, but if the mods required different structures it could get tricky.

I have set up several folders on one site, each with its own phpbb install, used to test themes and such in development. each of them connects to the same DB with the same prefixes. the one detail that I make sure of is the structure of the database. What I have done in the past is set it up with a new table prefix, then, once I am sure that each has the same structure, I change the required code to flip it to the other table prefix.

In short, unless they have the same structures, I wouldn't do it. If they do have the same structures, I would do it, AFTER you make full backups.