MyDump error: Field Engine not found

rsandies2 · Post by **rsandies2** » Mon 14 Aug 2006 14:21

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.

Antaeus · Post by **Antaeus** » Tue 15 Aug 2006 07:22

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

rsandies3 · Post by **rsandies3** » Wed 16 Aug 2006 13:50

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

Antaeus · Post by **Antaeus** » Thu 17 Aug 2006 06:40

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.

rsandies3 · Post by **rsandies3** » Thu 17 Aug 2006 19:15

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

rsandies3 · Post by **rsandies3** » Fri 18 Aug 2006 20:05

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.

Devart Forums