Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 30 Jul 2008, 01:59
c4smok c4smok is offline
 
Join Date: Jun 2007
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
Reply With Quote
  #2  
Old 30 Jul 2008, 07:50
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
As long as the MySQL user for vBulletin has access to the other database, you can use the standard MySQL "database.table" syntax.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
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.
Reply With Quote
  #3  
Old 30 Jul 2008, 23:19
c4smok c4smok is offline
 
Join Date: Jun 2007
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.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

The Error msg

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Thanks for your time again,
c4smok

Last edited by c4smok; 31 Jul 2008 at 02:20.
Reply With Quote
  #4  
Old 31 Jul 2008, 04:11
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
Try mysite_database2.table_servusers with the `.
Reply With Quote
  #5  
Old 31 Jul 2008, 04:41
c4smok c4smok is offline
 
Join Date: Jun 2007
its working =)

your great

thanks,
c4
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:19.

Layout Options | Width: Wide Color: