Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Altering table engine ARIA => InnoDB faulty

Berthold's profile image Berthold posted 3 months ago in General Permalink

Hello,

just a notice for possible improvements:

When doing an ALTER TABLE DB.table ENGINE InnoDB;

on an ARIA table it fails with / SQL-Error (1005): Can't create table DB.table (errno: 140 "Wrong create options") /

because of the ROW_FORMAT=PAGE

in the ARIA table.

Removing this by hand solved the problem.

Berthold's profile image Berthold posted 3 months ago Permalink

Checked with HeidySQL 12.4.0 / Windows.

ansgar's profile image ansgar posted 3 months ago Permalink

For me that worked without errors in HeidiSQL's table designer.

Created the table:

CREATE TABLE aria_1 (id INT) ENGINE=Aria;

Altering:

ALTER TABLE `aria_1`
    ENGINE=InnoDB;

Please watch out for the row format dropdown in the "Options" tab of the table desigenr.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.