problem with MySql Embedded Server with InnoDB engine

[leo35420]

Hello:
I´m new user but i have a lot of time Reading this foro.

I have a problem with MySql Embedded Server with InnoDB engine. The projet show a Message “SQL Error: unknown table engine ‘InnoDB’”

I use Delphi 2007, Zeos 6.6.4-stable and My Sql 5.1 server. The same project with a database with myisan engine works fine

What's the problem? Embedded server don’t work with a InnoDB engine?

Thanks for your help. greetings. Leo.

[mdaems]

Hi,

Maybe a stupid question, but you didn't copy this from the embedded example in the zeoslib packages (dfm file):

Code: Select all

  object EmbeddedConnection: TZConnection
    Protocol = 'mysqld-4.1'
    Database = 'zeoslib'
    Properties.Strings = (
      'compress=yes'
      'dbless=no'
      'useresult=no'
      'timeout=30'
      'ServerArgument1=--basedir=./'
      'ServerArgument2=--datadir=./data'
      'ServerArgument3=--character-sets-dir=./share/charsets'
      'ServerArgument4=--language=./share/english'
      'ServerArgument5=--skip-innodb'
      'ServerArgument6=--key_buffer_size=32M')
    Left = 232
    Top = 176
  end

Because that disables the innodb engine on startup.

Mark

[leo35420]

Hi Mark, thanks for your reply:

No, I see and study the embedded demo but I don’t copy them.

The Properties section of the zconnection in my projet is empty and don´t exist any file “my.ini”. Don´t exist any parameter passed to the server

Thanks for your help. greetings. Leo.

[mdaems]

Can you execute the statement?

Code: Select all

show variables like 'have%' 

What's the result for innodb?

Mark

[leo35420]

Hi Mark, thanks for your reply:

then result is "NO"

Thanks for your help. greetings. Leo.

[mdaems]

This means your version of the embedded library isn't compiled with Innodb support. I'm using 5.0 version on windows. My version shows 'disabled' in stead of 'NO', which means support would be available when I had not set the skip-innodb option.

So I guess you'll have to look for an embedded server version which supports innodb.

Mark

[leo35420]

Hi Mark, thanks for your reply:

I go to download the 5.0 version

Thanks for your help. greetings. Leo.

[mdaems]

Leo,

Did you find a good version?

Mark

[leo35420]

No, only the 4.1 version works fine.
The 5.0 version don't include the libmysqld.dll file.
I downloaded all available files.
Geetings. Leo.

[zippo]

Hi!

Where can I get the embedded version..? I know 5.x is commercial, but I can't find even the 4.x version..

[fduenas]

You can download 5.1 GA version directly from mysql. latest 5.1 has included the embedded version and I think it includes the innodb support.