MySQL Forums
Forum List  »  Federated Storage Engine

Unknown storage engine 'FEDERATED'
Posted by: Tharpa roberts
Date: November 11, 2015 02:47PM

I am attempting to create a table using query like so:
CREATE TABLE our_content.`acq_documents` (
	`acq_documents_id` INT (11) NOT NULL AUTO_INCREMENT
	,`accession_no` VARCHAR(100) NOT NULL DEFAULT ''
	,`title` mediumtext
	,`product_code` VARCHAR(45) DEFAULT NULL
	,PRIMARY KEY (`acq_documents_id`)
	,UNIQUE KEY `accession_no_UNIQUE`(`accession_no`)
	,KEY `title`(`title`(100))
	,KEY `product_code`(`product_code`)
	) ENGINE=FEDERATED AUTO_INCREMENT = 174244 DEFAULT CHARSET = utf8
	CONNECTION='www@nsamysql101.sl4.as:3306/lnh_acquisitions/acq_documents'
	;
I am getting the following warning message:

1286 Unknown storage engine 'FEDERATED'
Using storage engine InnoDB for table 'acq_documents'

What is the cause of this message?

Options: ReplyQuote


Subject
Views
Written By
Posted
Unknown storage engine 'FEDERATED'
5383
November 11, 2015 02:47PM


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.