Go Back   vb.org Archive > vBulletin Article Depository > Read An Article > General Articles
Reload this Page Multiple forums - 1 user DB
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
Multiple forums - 1 user DB
krohnathlonman
Join Date: Feb 2004
Posts: 157

 

Show Printable Version Email this Page Subscription
krohnathlonman krohnathlonman is offline 06-09-2005, 10:00 PM
Without getting things horribly complicated lets just say the DB"s have to be on the same server

Telnet into your system. You may need root access to do this properly. Stop your MySQL service before doing anything much.

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 useractivation.*
rm -f userban.*
rm -f userfield.*
rm -f usergroupleader.*
rm -f usergrouprequest.*
rm -f usernote.*
rm -f userpromotion.*
rm -f usertextfield.*
rm -f usertitle.*
rm -f administrator.*
rm -f pm.*
rm -f pmreceipt.*
rm -f pmtext.*
rm -f user.*
rm -f usergroup.*
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/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/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/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/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/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
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/usergroup.frm usergroup.frm
ln -s /backup2/mysql/msusenet/usergroup.MYD usergroup.MYD
ln -s /backup2/mysql/msusenet/usergroup.MYI usergroup.MYI

Backup ALL DB's involved!

chmod +x the file you pasted that info into. ./ execute it.....

start MySQL back up.... You can see it in action at http://www.msusenet.com/ and the usenet sites linked in the header. There's some issues involved with this but its NO PHP code hacking at all! its a simple hackish way of doing it but its the easiest way I could think of.

Anybody have anything to add to this? Don't share your template file, I've received rather goofy results and broken quite a few things while sharing some of the other tables. YMMV
Reply With Quote
  #2  
Old 06-10-2005, 02:22 AM
krohnathlonman krohnathlonman is offline
 
Join Date: Feb 2004
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I've also done these on most of my network:

rm -f template.*
rm -f reputation.*
rm -f reputationlevel.*
rm -f ranks.*
rm -f profilefield.*
rm -f phrase.*
rm -f phrasetype.*
rm -f moderator.*
rm -f language.*
rm -f faq.*
rm -f bbcode.*
ln -s /backup2/mysql/msusenet/reputation.frm reputation.frm
ln -s /backup2/mysql/msusenet/reputation.MYD reputation.MYD
ln -s /backup2/mysql/msusenet/reputation.MYI reputation.MYI
ln -s /backup2/mysql/msusenet/reputationlevel.frm reputationlevel.frm
ln -s /backup2/mysql/msusenet/reputationlevel.MYD reputationlevel.MYD
ln -s /backup2/mysql/msusenet/reputationlevel.MYI reputationlevel.MYI
ln -s /backup2/mysql/msusenet/template.frm template.frm
ln -s /backup2/mysql/msusenet/template.MYD template.MYD
ln -s /backup2/mysql/msusenet/template.MYI template.MYI
ln -s /backup2/mysql/msusenet/ranks.frm ranks.frm
ln -s /backup2/mysql/msusenet/ranks.MYD ranks.MYD
ln -s /backup2/mysql/msusenet/ranks.MYI ranks.MYI
ln -s /backup2/mysql/msusenet/profilefield.frm profilefield.frm
ln -s /backup2/mysql/msusenet/profilefield.MYD profilefield.MYD
ln -s /backup2/mysql/msusenet/profilefield.MYI profilefield.MYI
ln -s /backup2/mysql/msusenet/phrase.frm phrase.frm
ln -s /backup2/mysql/msusenet/phrase.MYD phrase.MYD
ln -s /backup2/mysql/msusenet/phrase.MYI phrase.MYI
ln -s /backup2/mysql/msusenet/phrasetype.frm phrasetype.frm
ln -s /backup2/mysql/msusenet/phrasetype.MYD phrasetype.MYD
ln -s /backup2/mysql/msusenet/phrasetype.MYI phrasetype.MYI
ln -s /backup2/mysql/msusenet/moderator.frm moderator.frm
ln -s /backup2/mysql/msusenet/moderator.MYD moderator.MYD
ln -s /backup2/mysql/msusenet/moderator.MYI moderator.MYI
ln -s /backup2/mysql/msusenet/language.frm language.frm
ln -s /backup2/mysql/msusenet/language.MYD language.MYD
ln -s /backup2/mysql/msusenet/language.MYI language.MYI
ln -s /backup2/mysql/msusenet/faq.frm faq.frm
ln -s /backup2/mysql/msusenet/faq.MYD faq.MYD
ln -s /backup2/mysql/msusenet/faq.MYI faq.MYI
ln -s /backup2/mysql/msusenet/bbcode.frm bbcode.frm
ln -s /backup2/mysql/msusenet/bbcode.MYD bbcode.MYD
ln -s /backup2/mysql/msusenet/bbcode.MYI bbcode.MYI

Warning: template generally makes the DB unusable but with some work you can get them to share
Reply With Quote
  #3  
Old 06-16-2005, 10:13 PM
mgurain's Avatar
mgurain mgurain is offline
 
Join Date: Apr 2005
Location: KSA - Qatif - Al-Jarodiah
Posts: 345
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Hello,,

Can you help krohnathlonman on the following request please :

How do I run multiple forums sharing same users

because I am not sure if you are talking about the same thing or not !

thanks in advance,,
Reply With Quote
  #4  
Old 06-17-2005, 09:36 PM
krohnathlonman krohnathlonman is offline
 
Join Date: Feb 2004
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
you could get it done this way but you do need a few licenses.... Also I can't hold your hand through this... If you don't understand command line linux and symbolic links don't even try it You could always pay somebody to do it but I'm not for hire....
Reply With Quote
  #5  
Old 06-27-2005, 04:24 PM
TheComputerGuy's Avatar
TheComputerGuy TheComputerGuy is offline
 
Join Date: Oct 2001
Location: TX
Posts: 580
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I think I might try this with mysecond license

What happens if the Register on Site B, but site B is using Site A's user dB?
Reply With Quote
  #6  
Old 06-28-2005, 01:19 PM
krohnathlonman krohnathlonman is offline
 
Join Date: Feb 2004
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
simple, you can log into either site with the same user/pass

Also just to give you guys proper notice, I've run into a LOT of problems when trying to do this with the template table. The best best is to set a cron tab up and copy this to the various sites like every day that should keep your stylizations the same. the style table will be needed only if you have more than 1 style to choose from.
Reply With Quote
  #7  
Old 06-29-2005, 03:30 AM
TheComputerGuy's Avatar
TheComputerGuy TheComputerGuy is offline
 
Join Date: Oct 2001
Location: TX
Posts: 580
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I want to have Site A have abrown theme...but site B to have a greenish theme.

So I just would leave the templates alone wouldn't I?
Reply With Quote
  #8  
Old 06-30-2005, 01:33 PM
krohnathlonman krohnathlonman is offline
 
Join Date: Feb 2004
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
yeah, leave the templates alone and you're set.
Reply With Quote
  #9  
Old 09-19-2006, 07:09 PM
lightsout lightsout is offline
 
Join Date: Jan 2005
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Anyone try this on 3.6.* yet?
Reply With Quote
  #10  
Old 09-21-2006, 07:26 AM
Kurisu Kurisu is offline
 
Join Date: Aug 2002
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by lightsout
Anyone try this on 3.6.* yet?
Yes, but with a custum hack. And I'm not using one database but rather I synch the users and add new registrations to all forums.
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

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
Forum Jump


All times are GMT. The time now is 09:37 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04758 seconds
  • Memory Usage 2,292KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_article
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete