maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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