Temporary tables for views exported as Isam

Jelmer's profile image Jelmer posted 11 months ago in Import/Export Permalink

Hi Ansgar,

We just found out that when exporting a database with views, the exporter created temporary tables using MyISAM, which is not supported by Mariadb (at least, not the version I use in our dockers). I don't know if this is a MysqlDump issue or something in your code.

Our workaround of course was not exporting the views (not a problem in this case). But maybe this is something you want to know.

Kinds regards, Jelmer

ansgar's profile image ansgar posted 11 months ago Permalink

Oh thanks for the hint. This engine=MyISAM is indeed hardcoded in HeidiSQL, which makes no sense. I did that 15 years ago in commit:a0c0bc1f4ccb9a32bb58f5b6dde29927280328e1, and never touched the line of code again :)

Will remove the engine clause, so MySQL and MariaDB apply their whatever default value.

Code modification/commit 84f2e95 from Ansgar Becker <anse@heidisql.com>, 11 months ago, revision 12.10.0.7060
Create helper table with the servers' default engine when exporting a view. See https://www.heidisql.com/forum.php?t=44125
Jelmer's profile image Jelmer posted 11 months ago Permalink

Thanks!

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