2

I installed Percona Server 5.6.12-rc60.4, when I want create table such as :

CREATE TABLE IF NOT EXISTS `mydb`.`table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 64 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
) ENGINE = XtraDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;

this error occurred:

 #1286 - Unknown storage engine 'XtraDB'

How can I create a table with XtraDB engine?

Arash Mousavi
  • 673
  • 2
  • 12
  • 21

1 Answers1

5

XtraDB replaces InnoDB (it's compatible and a drop in replacement), so just add ENGINE = InnoDB

However, it should be the default in MySQL 5.5.x onwards

gbn
  • 70,237
  • 8
  • 167
  • 244