maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

how do someone convert a Aria table to another engine?
MyISAM and InnoDB results in the same error
___________________________________________________________

MariaDB [dbmail]> ALTER TABLE `systemevents` ENGINE = InnoDB;
ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the 
create option 'TRANSACTIONAL=1'

MariaDB [dbmail]> ALTER TABLE `systemevents` TRANSACTIONAL=0;
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [dbmail]> ALTER TABLE `systemevents` ENGINE = InnoDB;
ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the 
create option 'TRANSACTIONAL=1'
___________________________________________________________

CREATE TABLE `systemevents` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DeviceReportedTime` datetime DEFAULT NULL,
  `FromHost` varchar(30) CHARACTER SET latin1 COLLATE latin1_german1_ci 
NOT NULL,
  `Message` text,
  `SysLogTag` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FromHost` (`FromHost`),
  KEY `SysLogTag` (`SysLogTag`),
  KEY `DeviceReportedTime` (`DeviceReportedTime`)
) ENGINE=Aria AUTO_INCREMENT=698044 DEFAULT CHARSET=utf8 PACK_KEYS=0 
PAGE_CHECKSUM=0 DELAY_KEY_WRITE=1 ROW_FORMAT=PAGE TRANSACTIONAL=0

Attachment: signature.asc
Description: OpenPGP digital signature