Re: [Maria-discuss] MariaDB 10: how to convert Aria table to InnoDB?

Hi, Reindl! On Mar 02, 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

Try TRANSACTIONAL=DEFAULT. Regards, Sergei