Multiple forums - 1 user DB
 

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

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

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,,

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....

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?

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.

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?

yeah, leave the templates alone and you're set.

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.

Is there any way to do this with out SSH access to the database server? I'm on shared hosting and have access to the main forum files server, but not the database server.

similar to how we did it a while back. nice post.