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.