Menu
▾
▴
#3020 (ok 3.3.3) Changing from Maria to MyISAM not possible
fixed
1
2013-06-11
2010-04-07
No
It is not possible to change from Maria to MyISAM storage engines, MySQL fails with following error:
Error: #1478 Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1'
I guess that table operations should have checkbox for TRANSACTIONAL or automatically disable it when switching to MyISAM.
Discussion
Well actually the checkbox is present, but is not applied when switching from MARIA to MyISAM.
Running the engine change with plain SQL doesn't output any error, weird ...
This run fine:
ALTER TABLE `hu` ENGINE=INNODB;
ALTER TABLE `hu` ENGINE=MYISAM;
ALTER TABLE `hu` ENGINE=MARIA TRANSACTIONAL=1;
ALTER TABLE `hu` ENGINE=MYISAM;
I think it's a Maria bug. phpMyAdmin is not sending the TRANSACTIONAL clause when the user asks to switch engine to MYISAM, but somehow the clause is remembered.
After
ALTER TABLE `hu` ENGINE=MARIA TRANSACTIONAL=1;
ALTER TABLE `hu` ENGINE=MYISAM;
if you try
SHOW CREATE TABLE `hu`;
you will see that the engine is MYISAM and the TRANSACTIONAL clause is there!
Implemented a workaround for this exaggerated error. See my comments in the code about the rationale.