I agree with Harald here! -- Peter On Mon, Mar 2, 2015 at 2:37 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
Am 02.03.2015 um 14:26 schrieb Ian Gilfillan:
This is probably because strict mode is set. If unset, it should return a warning, not an error. From MariaDB 10.1.2, you can use: SET STATEMENT sql_mode='' FOR ALTER TABLE `systemevents` ENGINE = InnoDB; which will unset strict mode just for that query, otherwise for older versions just set it off and on again for the session to alter.
indeed *but* why does "TRANSACTIONAL=0" don't go away after convert to InnoDB?
'show create table' looks like below and the seems to confuse phpMyAdmin
i am pretty sure that i played around switching bewteen Aria/MyISAM/InnoDB with 5.5 multiple times and "sql-mode = STRICT_ALL_TABLES" is enabled on all machines for years - strange
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=InnoDB AUTO_INCREMENT=698045 DEFAULT CHARSET=utf8 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED TRANSACTIONAL=0
On 02/03/2015 15:09, Reindl Harald wrote:
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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp