Replication on one machine

TomTom101

Hey guys,

Simply said, imagine this scenario:
A MySQL server with about 10 databases: A and 1 to 9.
Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database.

So how do I tell MySQL which databases I consider to be slaves and master??

Thanks very mouch for your help!

Thomas

sfullman

dont understand you rquestion. Are you talking about a permissions issue? is this table replicated once from the master table? Are you updating into the records of the other tables from the master table? And what triggers this?

The question is too broad right now.

tomhath

Database replication is explained here:

http://www.mysql.com/doc/en/Replication.html

But you don't need to do any replication if the databases are all on the same server. Just qualify the table name with the database name (I found this answer on http://www.bitmechanic.com )

SELECT * from dbone.tableone, dbtwo.tabletwo
WHERE dbone.tableone.col = 4
AND dbone.tableone.shared = dbtwo.tabletwo.shared;