English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottomPage: 1
TOPIC: Link from one DB to another
#5701
Link from one DB to another 14 Years, 1 Month ago Karma: 0
I have Community builder installed and I have been able to create a slave that utilises the master CB tables. The slave’s tables are stored in the database with CB.

I wish to create another slave and have that slave's tables stored in a separate (second) database. I also wish the slave to utilise the tables (link) in the first database.

Is this possible?

Many thanks.
clubroom
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5702
Re: Link from one DB to another 14 Years, 1 Month ago Karma: 54
YES this is possible but you need to have the MySQL User privileges that can access both DB.

If you are using shared hosting, this might be more difficult to get the MySQL user privileges that can access different DB and create views between DBs.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5706
Re: Link from one DB to another 14 Years, 1 Month ago Karma: 0
Many thanks for the reply, very much appreciated. What is it that I should be asking the host provider in the tech speak that they would understand?

Is it that “I need the capability / privileges to create views between DBs”


cheers
clubroom
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5708
Re: Link from one DB to another 14 Years, 1 Month ago Karma: 54
You need that your MySQL user has access on different DB and that it is allowed to CREATE and SHOW VIEWS between the DBs (cross DB)
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla