Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
[How To] Multiple Forums with shared user database
we_are_borg
Join Date: Aug 2004
Posts: 108

by we_are_borg we_are_borg is offline 22 Nov 2010

This guide is to let you run multiple vBulletin software from one user database. Please make sure you understand what is written and you have knowledge of Linux commands to make it very clear USE AT OWN RISK.

Original Idea is from krohnathlonman http://www.vbulletin.org/forum/showthread.php?p=1289985 but is for vBulletin 3, i only adapted it for vBulletin 4. Used his example of the path so that you can compare.

You need multiple licenses if you are going to use this (in many cases) read
http://www.vbulletin.com/forum/showt...ifferent-skins
if you do not under stand what is written please ask a staff member at vBulletin.com

USE AT OWN RISK, ALWAYS MAKE BACKUPS.

This is for new forums only you need to merge stuff if you want to include establish forums but this will not be handled here. This is made for vBulletin 4.0.8+ you can adapted it for versions below 4.0.8, if the file does not exist then do not make an ln for it.

There will be issues to deal with you can better test this first do not try this on a live site. First test a few times then do this on a live site, but always remember to make backups.

We can't say it enough BACKUP DATABASE there is no excuse to do so.

You need access to where the database write the files it self this is mostly only the case under VPS and Dedicated servers. You need to stop the database server first, then and only then you can remove the files. One line is one command. If you do not understand the commands let some one else do it that is saver.

Change into the directory where your secondary forum is. Create a shell script and paste these contents into it: (obviously change /backup2/mysql/msusenet/ to the location of your main DB)

rm -f administrator.*
rm -f pm.*
rm -f pmreceipt.*
rm -f pmtext.*
rm -f pmthrottle.*
rm -f user.*
rm -f useractivation.*
rm -f userban.*
rm -f userchangelog.*
rm -f userfield.*
rm -f usergroup.*
rm -f usergroupleader.*
rm -f usergrouprequest.*
rm -f userlist.*
rm -f usernote.*
rm -f userpromotion.*
rm -f usertextfield.*
rm -f usertitle.*

Now that we have done the removing of the files we need to make symbolic links.

ln -s /backup2/mysql/msusenet/administrator.frm administrator.frm
ln -s /backup2/mysql/msusenet/administrator.MYD administrator.MYD
ln -s /backup2/mysql/msusenet/administrator.MYI administrator.MYI
ln -s /backup2/mysql/msusenet/pm.frm pm.frm
ln -s /backup2/mysql/msusenet/pm.MYD pm.MYD
ln -s /backup2/mysql/msusenet/pm.MYI pm.MYI
ln -s /backup2/mysql/msusenet/pmreceipt.frm pmreceipt.frm
ln -s /backup2/mysql/msusenet/pmreceipt.MYD pmreceipt.MYD
ln -s /backup2/mysql/msusenet/pmreceipt.MYI pmreceipt.MYI
ln -s /backup2/mysql/msusenet/pmtext.frm pmtext.frm
ln -s /backup2/mysql/msusenet/pmtext.MYD pmtext.MYD
ln -s /backup2/mysql/msusenet/pmtext.MYI pmtext.MYI
ln -s /backup2/mysql/msusenet/pmthrottle.frm pmthrottle.frm
ln -s /backup2/mysql/msusenet/pmthrottle.MYD pmthrottle.MYD
ln -s /backup2/mysql/msusenet/pmthrottle.MYI pmthrottle.MYI
ln -s /backup2/mysql/msusenet/user.frm user.frm
ln -s /backup2/mysql/msusenet/user.MYD user.MYD
ln -s /backup2/mysql/msusenet/user.MYI user.MYI
ln -s /backup2/mysql/msusenet/useractivation.frm useractivation.frm
ln -s /backup2/mysql/msusenet/useractivation.MYD useractivation.MYD
ln -s /backup2/mysql/msusenet/useractivation.MYI useractivation.MYI
ln -s /backup2/mysql/msusenet/userban.frm userban.frm
ln -s /backup2/mysql/msusenet/userban.MYD userban.MYD
ln -s /backup2/mysql/msusenet/userban.MYI userban.MYI
ln -s /backup2/mysql/msusenet/userchangelog.frm userchangelog.frm
ln -s /backup2/mysql/msusenet/userchangelog.MYD userchangelog.MYD
ln -s /backup2/mysql/msusenet/userchangelog.MYI userchangelog.MYI
ln -s /backup2/mysql/msusenet/userfield.frm userfield.frm
ln -s /backup2/mysql/msusenet/userfield.MYD userfield.MYD
ln -s /backup2/mysql/msusenet/userfield.MYI userfield.MYI
ln -s /backup2/mysql/msusenet/usergroup.frm usergroup.frm
ln -s /backup2/mysql/msusenet/usergroup.MYD usergroup.MYD
ln -s /backup2/mysql/msusenet/usergroup.MYI usergroup.MYI
ln -s /backup2/mysql/msusenet/usergroupleader.frm usergroupleader.frm
ln -s /backup2/mysql/msusenet/usergroupleader.MYD usergroupleader.MYD
ln -s /backup2/mysql/msusenet/usergroupleader.MYI usergroupleader.MYI
ln -s /backup2/mysql/msusenet/usergrouprequest.frm usergrouprequest.frm
ln -s /backup2/mysql/msusenet/usergrouprequest.MYD usergrouprequest.MYD
ln -s /backup2/mysql/msusenet/usergrouprequest.MYI usergrouprequest.MYI
ln -s /backup2/mysql/msusenet/userlist.frm userlist.frm
ln -s /backup2/mysql/msusenet/userlist.MYD userlist.MYD
ln -s /backup2/mysql/msusenet/userlist.MYI userlist.MYI
ln -s /backup2/mysql/msusenet/usernote.frm usernote.frm
ln -s /backup2/mysql/msusenet/usernote.MYD usernote.MYD
ln -s /backup2/mysql/msusenet/usernote.MYI usernote.MYI
ln -s /backup2/mysql/msusenet/userpromotion.frm userpromotion.frm
ln -s /backup2/mysql/msusenet/userpromotion.MYD userpromotion.MYD
ln -s /backup2/mysql/msusenet/userpromotion.MYI userpromotion.MYI
ln -s /backup2/mysql/msusenet/usertextfield.frm usertextfield.frm
ln -s /backup2/mysql/msusenet/usertextfield.MYD usertextfield.MYD
ln -s /backup2/mysql/msusenet/usertextfield.MYI usertextfield.MYI
ln -s /backup2/mysql/msusenet/usertitle.frm usertitle.frm
ln -s /backup2/mysql/msusenet/usertitle.MYD usertitle.MYD
ln -s /backup2/mysql/msusenet/usertitle.MYI usertitle.MYI

Last edited by we_are_borg; 22 Nov 2010 at 17:25.. Reason: Auto-Merged DoublePost
Views: 4944
Reply With Quote
Comments
  #2  
Old 27 Nov 2010, 20:10
we_are_borg we_are_borg is offline
 
Join Date: Aug 2004
Reserved for expansion.
Reply With Quote
  #3  
Old 27 Nov 2010, 20:38
TheRageIsOn TheRageIsOn is offline
 
Join Date: Mar 2010
I have done a different approach!

I use a mix from views and 1 codemodification to
replace the tables i want to have shared to the main table !

works for me

I would never tamper with the db's very own structure.
Reply With Quote
  #4  
Old 29 Nov 2010, 16:51
we_are_borg we_are_borg is offline
 
Join Date: Aug 2004
Originally Posted by TheRageIsOn View Post
I have done a different approach!

I use a mix from views and 1 codemodification to
replace the tables i want to have shared to the main table !

works for me

I would never tamper with the db's very own structure.
Well its more of a cheat because you redirect parts of the database and this system you can only use when setting up new sites to do this on an existing database it takes long preparation to do so
Reply With Quote
  #5  
Old 01 Dec 2010, 15:34
Carnage Carnage is offline
 
Join Date: Jan 2005
This may go horrifically wrong if you ever upgrade your mysql.

You are FAR FAR safer using views.
__________________
www.giveupalready.com

If you want/need to contact me, best thing is to pm me on that site, username Carnage.
Reply With Quote
  #6  
Old 01 Dec 2010, 16:06
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
why not just run this mod?
http://www.vbulletin.org/forum/showthread.php?t=254197
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
  #7  
Old 03 Dec 2010, 05:53
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
wow!
thought it would be much easier
Reply With Quote
  #8  
Old 22 Jul 2011, 06:19
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Originally Posted by Brandon Sheley View Post
Because Google sees that as duplicate content. Its really a great mod, but its far from complete. It needs more development.
Reply With Quote
  #9  
Old 01 Nov 2012, 20:01
Dorgham's Avatar
Dorgham Dorgham is offline
 
Join Date: May 2012
Needs a lot of effort
But he did a great job all standards
__________________
AdSense revenue sharing 100% - [ Hanan ]
News, egypt : أخبار مصر - Photo, picture : صور
Reply With Quote
Reply

Similar Article
Article Author Type Replies Last Post
Shared user database for multiple forums, same server CyberRanger vBulletin 3.0 Full Releases 117 18 Feb 2009 07:21



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

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 04:59.

Layout Options | Width: Wide Color: