I have read this federate TABLE and now I would like to know what to do if I want to create the test_table
(see this example in the link) from remote?
As I do understand that test_table
must be created on the federate server before. But I would like to create this by doing so from my local server.
Can anyone help?
UPDATE:
I tried to create a minimal version of the remote table by my own manually and let alter table tablename add columnname
run. Now I get this error. (The Fields is ACA.PA in table levermanneasypivot.)
Field: ACA.PA does not exists
Error at: Do an alter ADD COLUMN ACA.PA @ easy
Error at: cmd: alter table `levermanneasypivot` add ` ACA.PA` int(9)
default NULL;
Errormsg: cmd: Table storage engine for 'levermanneasypivot' doesn't have this option
Thanks a lot.
This is not possible, as described in 15.9.3 FEDERATED Storage Engine Notes and Tips:
The following items indicate features that the
FEDERATED
storage engine does and does not support:
- The remote table that a
FEDERATED
table points to must exist before you try to access the table through theFEDERATED
table.
You can use the connect
command to connect to a remote server from inside the mysql
client. But then, you could just connect to the remote server with mysql -h remote_addr
directly.