Women in Technology

Hear us Roar



Article:
  MySQL Federated Tables: The Missing Manual
Subject:   Problem to create table as federated engine
Date:   2009-02-25 09:26:47
From:   valdezr
Although I specify the engine of type federated in my server2 sandbox, when I run the information.schema query, I see the tables were created like MyISAM instead of federated.
Here is one of my create tables query:


create table tnokey_fed (
id int not null primary key,
word varchar(30) not null
)
engine=federated
connection='mysql://server2usr:msandbox@127.0.0.1:5001/test/tnokey';


What could be wrong. I hope you can advice me.
Thanks in advance.