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
