Devart Forums

I have a problem with MyDump on a specific server.
I have only user access to this server.
The remote server was recently upgraded from MySQL 3.23 to 5.0.
MyDump now returns an EDatabaseError exception: Field ‘Engine’ not found.
On a local server it works fine – regardless of server version.

I am using MyDAC 4.30.1.17 with direct access and Delphi 2006
I suspect that the problem is in the server configuration (accidental or intentional).

Any insights or work arounds?

Thank you.

Please try to determine for what server object(s) does the problem appear. Also supply us with exact version of MySQL Server.

Some details:

Server: mysql-standard-5.0.0-alpha-dec-osf5.1-alphaev67

The problem seems to be isolated to MyDump.
MyDump will create a script file containing only 7 header lines.

No problem with connection, connection dialog, or query.
Can extract table names from connection.

My guess is that the identity of the storage engine type may not be provided by the server. That might give the [ field ‘engine’ not found ] error and the create table script would fail.

It seems like the create table script needs to end with ENGINE=MyISAM, but it can not access the 'engine' field - so it ends. But this is just an uninformed guess.

Thank you,
rsandies

MyDAC does not support alpha versions of MySQL server. Please use stable versions. As we know last stable version of MySQL Server is 5.0.24.

Nothing I can do, but thank you for your assistance.

Some more testing:

I tried to access the problem server using SQLyog and EMS MyManager.
Both connected and exported table creation and row data without error.