Defaintly, but he has only 3 and until he upgrade he has no other option if he wants to add a new forum to his site.

I once set up IPB, MKPortal, a directory script (can't remember which one) and MediaWiki off of one database and only problem I had was it was a complete and total pain to use PhpMyAdmin to edit it. Site ran completely fine with 200+ tables in there. Didn't know about the Security Policy though, that may have been a prob if the host had noticed.

__________________
Bob's Bit of the Web
Into Blogging? Want to talk about it or need help with something? Join us at the Blogging Café.

The problem you have with security is simple. If there is an sql injection or other hack that ends up giving a hacker access to your database, instead of them getting access to one database, they now have access to all of them. The seperation of databases isolates what a hack of that type can affect. One install of a forum can easily be 100+ tables. I understood that it was his only option I just wanted to make sure that we were saying it was possible as it was his only option and not advocating it because it is a fairly unsafe practice.

__________________
Do not post your PF private key in public.

Did I help you with this post? If so, pls click the rep button or send money.

Fare enough, so we are saying if we gets a new forum to do it if he hasn't upgraded yet, but as soon as he upgrades he should defaintly seperate them for security.

__________________
Bob's Bit of the Web
Into Blogging? Want to talk about it or need help with something? Join us at the Blogging Café.

Ah, i wasnt aware it was possible to safely split them back into two databases, how could this be done quickly and efficiently.
Please remember i have no expereince at editing and adding / removin database tables

__________________

If you are buying an already established forum, then you will be restoring that forums database. I am not sure changing the prefix of the existing and the db to be restore would be easy or not. Better option would be to restore the new forums database on your faq database, since the queries to the faq database would be lesser then on the forum database.

__________________
India Travel Forum | Why most forums fail within 1 year! | Free Travel Directory

hmm, I have did it before and it is easy enough when you know what to do, but I'm not very good at giving descriptions of how to do things.

Basically you need to export the tables for the forum you are moving then import them into the new databse and change the config settings on your board to point to the new database. Once you are certain it is working you can then drop the tables from the old database.

Like I said I'm not the best at describing these things and it looks simple enough reading that if you've done it before

If when the time comes that you need this, take a look through the database and see how you feel. If your not to happy about trying it give me a shout and I'll happily do it for you. At least if you have PhpMyAdmin (not to happy about working in databases with anything else )

__________________
Bob's Bit of the Web
Into Blogging? Want to talk about it or need help with something? Join us at the Blogging Café.

What Bob said.

Five steps: dump, import, change config, verify, drop.

Use phpMyAdmin or equivalent to dump the tables you are moving, then import the dump into the destination database. Alter the configuration of the software that uses the tables you copied to use the new tables. Once you are SURE everything works right, drop the tables from the old database.

I've done this many times. Sometimes phpMyAdmin chokes on its own comments and you have to remove them from the dumped file. (I have a text editor with regex find/replace which will do that in one click. /^-- .*$/)

And the DB I mentioned that has six applications' worth of data in it has "only" about 140 tables. (~30 per phpBB2, 70 for phpBB3, and 2, 7, and 3 for my three homebrew apps.) Not too big to manage with phpMyAdmin but by no means small either. Due to the prefixes all related tables are together.

__________________
Temporarily between forums

The Database with the FAQ on is rarely used, the one with the Gallery on is quite heavily used, as is the forums database.

I have checked for phpMyAdmin, it appears it requires installing on another database (or a previous one) according to my servers Fantastico program

__________________

Strange that it would need installing. Usually there is a link to it on the MySQL page where you create/delete your databases. As it comes with (in my experience anyway) the hosting account. You sure your not looking at phpadsnew in there

__________________
Bob's Bit of the Web
Into Blogging? Want to talk about it or need help with something? Join us at the Blogging Café.

O bugga, yes its phpAdsnew!
phpMyadmin isnt in there

__________________