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

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