Database table "Engine" missing in table options dialog

[expired user #8611]'s profile image [expired user #8611] posted 7 years ago in General Permalink

whenever I click on a bigger database table the "Engine" drop-down does not show the correct storage engine, but none (see screenshot). This happens for both InnoDB and MyISAM tables. When I set the storage engine using the drop-down and save HeidiSQL performs an alter table engine statement. After that finishes the behavior is the same - no storage engine in the drop-down for the selected table. Both bigger tables use partitions. This observation was made with MySQL 5.7 and 5.6.

1 attachment(s):
  • Screenshot_2017-06-22_164223

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