MyDAC 5.20.0.13 Embedded don't work with libmysqld.dll version 4 and 5 with innodb Tables

[Dimon]

just to ensure, does my --innodb parameter declared in the right place correctly?

Yes, you correctly declared this parameter.

Dmitry said I have to include parameter --innodb in the TMyEmbConnection.Params, as he suggested, I've added it. But it did not work well in my code. It still did not find the innodb tables.

Are you sure you have created InnoDB tables? Check, if files with these tables exist in your database directory. Try to create a new InnoDB table and check whether it is accessible.

[bprasetio]

Are you sure you have created InnoDB tables? Check, if files with these tables exist in your database directory. Try to create a new InnoDB table and check whether it is accessible.

The files are exist. If I create the new InnoDB tables, it works.

but if I load the existing tables (copied from existing server - all files in the data folder, with and without ibdata file, of course the server / service is stopped), it does not work. But it works for MyISAM.

[Dimon]

In order to use InnoDB tables, perform the next steps:
- Before using an Embedded server stop the MySQL server. If you want to use a copy of database, copy of all files in the data folder.
- Set the --datadir=PathToDataDir parameter in the TMyEmbConnection.Params list.
- Make copy of a my.ini file, which MySQL server use. Find the line [mysqld] and change it to [embedded].
- Delete from this file all parameters, which is started no from 'myisam' or 'innodb'.
- Set the --defaults-file=PathToMyini parameter in the TMyEmbConnection.Params list.
- Set Embedded connection.