View a different port table.

User, date Message
Written by Fernando Real
2 years ago
Category: General
1 posts since Fri, 16 Nov 12
Install Multiple instances of MySQL on your Windows port 3306 and schema1 table1 and in the second instance port 3307 with Schema2 and table2. The question is how I can make a query instance being in port 3306 table2 read data port 3307.
Something like this or do not know how.
Select * from schema.dbf.tabla2
Anyway thank you very much for the help.
Written by jfalchMoney, Euro
2 years ago
406 posts since Sat, 17 Oct 09
AFAIK: you can't.

You can define two different sessions in Heidisql, one for each instance, and you can connect to both sessions, and then you can switch between sessions by clicking on the session name in the tree on heidisql´s left. You can, however, only execute queries within the currently active session; AFAIK, there is no way to specify a host or session name prefix in MySQL´s query language.

A workaround could be to install in each instance proxies to single tables in the other instance; you could use the FEDERATED storage engine for this - cf here for details.

Please login to leave a reply, or register at first.