MySQL 4.0.18 InnoDB configuration issues on SuSE 9.1 Pro

[JohnD]

Hello,

I've tried resolving this issue in a SuSE newsgroup, but after trying
their suggestions and working on this issue for far too long already, I
decided to try this list as it may be a more appropriate discussion area.

I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using
the default RPM's that came with the distribution.

I created a simple database (one table with InnoDB engine type) and have
tried running some ODBC source against it to test transactions, but I
get the error that the server does not have transactions enabled.

I was directed to enable transactions in the configuration file
(/etc/my.cnf) by uncommenting the lines for innoDb use. However, after
uncommenting these lines and running mysqld from the commandline
(according the online Manual), to generate InnoDB support tables, I get
the following error:

mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/'

I've tried removing the RPM's and starting from scratch, but cannot get
past this error and successfully test transactions in my unit tests.

Am I missing something?

Thanks,
John

[Peter Bradley]

Ysgrifennodd JohnD:

Hello,

I've tried resolving this issue in a SuSE newsgroup, but after trying
their suggestions and working on this issue for far too long already, I
decided to try this list as it may be a more appropriate discussion area.

I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using
the default RPM's that came with the distribution.

I created a simple database (one table with InnoDB engine type) and have
tried running some ODBC source against it to test transactions, but I
get the error that the server does not have transactions enabled.

I was directed to enable transactions in the configuration file
(/etc/my.cnf) by uncommenting the lines for innoDb use. However, after
uncommenting these lines and running mysqld from the commandline
(according the online Manual), to generate InnoDB support tables, I get
the following error:

mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/'

I've tried removing the RPM's and starting from scratch, but cannot get
past this error and successfully test transactions in my unit tests.

Am I missing something?

Thanks,
John

John,

Did you ever get an answer for this. I have a similar problem

Peter

[Eric Clack]

You've probably discovered this by now, but you need to install the
mysql-max package from YaST to get InnoDB working. Once you've done
that, go to this page for configuration options, which you should add
to /etc/my.cnf

http://dev.mysql.com/doc/mysql/en/in...iguration.html

Hope this helps :-)