MySQL

We have tested the ITP/MDK Repository with ODBC driver MySQL 3.51.8, and with version 4.0.18 of the MySQL software.

Adapting MySQL for use with the ITP/MDK Repository

The ITP/MDK Repository does not support the default MySQL executable because this executable does not support the InnoDB table handler. This table handler is necessary for the ITP/MDK Repository because it supports transactions.

As database service mysqld-max-nt.exe must be used. This is not the default service. To alter the default service (mysql.exe):

1. Type on the command line: mysqld.exe --remove
2. Type on the command line: mysqld-max-nt.exe --install
3. Adjust the MySQL configuration for InnoDB use as described in the MySQL Manual.

Note

If MySQL is not properly configured it will fall back to the default handlers that are not useable by the ITP/MDK Repository.

We have tested the ITP/MDK Repository with MySQL 5.1.30. To be able to use MySQL with ODBC mysql-connector-odbc-3.51.27.msi must be installed. This installation is straight forward and available for download from the MySQL website.