MySQL Forums
Forum List  »  Federated Storage Engine

How to enable FEDERATED storage engine which is in disabled mode by default
Posted by: susmitha m
Date: December 16, 2010 12:33AM

Hi,
I am using MySQL 5.4 DB. I googled a lot and searched in forums also for enabling FEDERATED storage engine which is in disabled mode by default.

When i am executing query regarding Federated engine, it is showing error "Unknown storage engine".

query i executed is as:
CREATE TABLE `federated`.`federated_table1` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL DEFAULT '',
`other` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `other_key` (`other`)
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://user1:user1@localhost:3306/federated/test_table';

Options: ReplyQuote


Subject
Views
Written By
Posted
How to enable FEDERATED storage engine which is in disabled mode by default
17682
December 16, 2010 12:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.