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

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to