Okay, unregard my question. I figured out what I was doing wrong.

It's too embarrassing to tell you guys.

Thanks,
--Walt

-----Original Message-----
From: Weaver, Walt 
Sent: Monday, November 26, 2001 9:52 AM
To: [EMAIL PROTECTED]
Subject: Using Berkeley tables -- how to set up?


I'm a relative newbie to MySQL (most of my experience is with Oracle) and am
currently trying to set things up to use the Berkeley tables with
transaction processing.

I downloaded the mysql-3.23.44.tar.gz source and installed it on Linux Red
Hat 6.2. I configured it with the --with-berkeley-db option, and doing a
mysqladmin variables shows have_bdb variable=yes and a number of bdb
variables enabled.

I started up the mysql daemon using safe_mysqld with the --bdb_logdir
option. The daemon started okay.

But, when I log into mysql and do a show logs nothing is returned. I set
autocommit to 0 and created a test table but doing a rollback or commit
after inserting rows returns the message: ERROR 1196: Warning:  Some
non-transactional changed tables couldn't be rolled back.

SO, I'm obviously doing something horribly wrong here. Anybody have any
ideas what I'm missing?  Anybody out there using Berkeley tables? I'm
currently a bit perplexed.

Thanks,
--Walt Weaver
  Bozeman, Montana


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to