![]() |
|
Thread Tools |
#1
|
|||
|
|||
multiple databases question
I currently run vbulletin forums with other services linked in to the same database. But it has started to become really hard to manage.. around over 200+ tables..
I was wondering if there was a way I could put my services into another database and still use the plug-in system to have them linked into the forums for all the connections and vars. My current system I have one database with my services in tables of one database.. Thanks for reading, looking for a clean way to do this like a plugin on start or something. Thank you for your time, c4smok No members have liked this post.
|
#2
|
||||
|
||||
As long as the MySQL user for vBulletin has access to the other database, you can use the standard MySQL "database.table" syntax.
__________________
Former vBulletin.org Staff Member View My Modifications 29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x) Please do not PM me to ask for support - please use the relevant thread or forum. No members have liked this post.
|
#3
|
||||||||||||
|
||||||||||||
I seem to be getting a database error for the forum system when I try to use that.
This is the current code I use to bring over vars from other tables in the same database.
This is the changes I made based on your advice which I may not be doing correctly. The user for both databases have the same access also.
The Error msg
Thanks for your time again, c4smok No members have liked this post.
Last edited by c4smok; 31 Jul 2008 at 02:20. |
#4
|
|||
|
|||
Try mysite_database2.table_servusers with the `.
No members have liked this post.
|
#5
|
|||
|
|||
its working =)
your great thanks, c4 No members have liked this post.
|
![]() |
«
Previous Thread
|
Next Thread
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|
New To Site? | Need Help? |
All times are GMT. The time now is 09:19.