Getting federated table connection information

797 Views Asked by At

I have a number of federated tables on my MySQL 5.7.23 and MariaDB 10.1 servers (I was using CREATE SERVER syntax if this matter).

I can easily get a list of these tables using query:

SELECT * FROM `information_schema`.`TABLES` WHERE `ENGINE` = 'Federated';

However, I need to get connection information for all these tables:

CREATE TABLE `table` (
    -- table definition here
)
ENGINE=FEDERATED
CONNECTION='server/table' -- <= I would like to get this info
;

Not the servers I created that are in mysql.servers.

I could not find it in information_schema and mysql databases.

I can only get it from table.frm files or using SHOW CREATE TABLE table; query that is for one table only.

Is it possible to get what I want at all?

Thanks.

0

There are 0 best solutions below