Federated table does not show the connection URL

[expired user #6221]'s profile image [expired user #6221] posted 12 years ago in General Permalink
Hi ,
I'm working with the federated tables and when i try to alter the connection string for connection to the remote server , the application seems does not provide the utility for making changes. Thanks

Example
---------
ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://username:pass@serverip:3306/dbname/tablename';
ansgar's profile image ansgar posted 12 years ago Permalink
Yes, FEDERATE engine is not supported directly by HeidiSQL. Rarely used, so I propose you make changes via SQL query, not via table designer.
[expired user #1502]'s profile image [expired user #1502] posted 8 years ago Permalink

I missed this as well.

"SHOW CREATE TABLE tbl" returns the information:

CREATE TABLE `tbl` (
...
) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='server/tbl'

So it would be nice if HeidiSQL shows the connection info at least in "CREATE code" tab.

Thanks.

[expired user #10449]'s profile image [expired user #10449] posted 7 years ago Permalink

I agree with the OP. We use federated tables also, and, connection info should be there. This should include "create server" type connections as well, which would mean supporting adding and changing those. The danger here is using the create statement as shown in that tab for some purpose and destroying the connection. +1 for this feature.

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