I am searching for the following feature with my 2 XOOPS sites. hopefully this is possible with mysql


I got 2 startrek sites. with its own MySQL database.

i want the 2 sites to be almost identical. So they are have the same users, guestbook entries. etc.
this would work if you use only one database, but i want diffrent news and some diffrent blocks on the 2 sites so they have there own Database

Is it possible that you use some kind of MySQL simlinks ?

one site connects to database 1 and the other one to database 2

it is posible to "symlink" a table in database 2 to an table in database 1?
(this way the other site can use the same users as the other one)

another solution world be db replication, but is REALTIME replication possible specifying only tables replication? instead of a whole DB?


EDIT: XOOPS VERSION 2.2.X
MYSQL VERSION 4.1.X

What about the multisite hack?

This looks very promising

Thx in advance!