2 messages in com.mysql.lists.win32Compiling mysql with transaction support
FromSent OnAttachments
Prasanti Cherukuri10 Apr 2001 06:18 
Chris Owen11 Apr 2001 05:51 
Subject:Compiling mysql with transaction support
From:Chris Owen (COw@twowaytv.co.uk)
Date:04/11/2001 05:51:51 AM
List:com.mysql.lists.win32

I did the following (more by accident than by design) to include Berkeley DB support (which support transactions):

get the Berkeley DB from www.sleepycat.com and build it take the libdb32x.lib file (x depends on whether you've built it static or not), add this to the mysqld project libs in the defines part of the project add HAVE_BERKELEY_DB

it then builds with BDB support.

To create a BDB table do your usual create table... stuff but add type=bdb to the end. To check that it is a bdb table look in the db subdirectory of the data dir, you should find a your_table_name.bdb file.

I'm not sure if this is the correct procedure as I couldnt find any docs on it either.

I am experiencing a problem with update table... on the bdb table though, causing a dbug dialog to appear and mysqld to crash, not sure if this is because of something I am doing wrong.