Use one SQL Database for Multiple Programs... :)

[John Klyne]

...I am wondering if anyone has tried such thing? Does anyone know if something like this would work...?

I am trying to come up with a system that would enable one database to be used for more than just one program a, database requiring sites, such as, hosting... phpbb forums, joomla, advertising site, and whatever else you can think of, all on one database.

I am not sure if what I have said, makes sense but anyone able to enlighten me a little?

 

[callumacrae]

It works fine, I use WP and phpBB and my own custom stuff in the same database

~Callum

 

[galaxyAbstractor]

if yo can set a tableprefix in the application it should work. If you can't, then you have to edit the script yourself to use a unique prefix

 

[John Klyne]

Editing the script myself is not an option for my capabilities heh...

What do you mean, tableprefix...


Callum- Didn't know it would work heh Thanks for verifying.

Again, I appreciate the help you both have given, thank you.
From John Klyne.

 

[galaxyAbstractor]

Editing the script myself is not an option for my capabilities heh...

What do you mean, tableprefix...


Callum- Didn't know it would work heh Thanks for verifying.

Again, I appreciate the help you both have given, thank you.
From John Klyne.

scriptname_tablename instead of tablename

like phpbb_users or wp_posts

 

[John Klyne]

Ahh I see, ..for scriptname, where would I derive what to input for such strings.

 

[ChatIndia]

yeah it works cause vb4 uses only a single db for both its blog and forum. i was also wondering how to do that. thanks for bringing up this topic.

 

[John Klyne]

: )

Thanks viggie and Alex...helps me a lot.

 

[callumacrae]

Ahh I see, ..for scriptname, where would I derive what to input for such strings.

What do you mean?

If you mean what should you use a prefix, it really doesn't matter, but generally it's best to use something descriptive like wp_ for wordpress or vb_ for vBulletin

~Callum

~Callum

 

[John Klyne]

Understood, thank you all for your help.

 

[nandifamily]

when u install a script. u may see a table prefix field on the installation page. just pay attention to that.

 

[Sharky]

To clarify , the prefix is only used so different packages don't try and use the same table.

 

[John Klyne]

Yea I kind of figured Sharky...nandi family, will do thankyou for your help.

 

[Sharky]

Good luck