How To Start mysqld to Support the BDB Storage Engine in MySQL?

The default "mysqld" program does not support the BDB storage engine. If you want to use the BDB storage engine, you can start MySQL server with the "mysqld-max" program.

The tutorial exercise below shows you how to start "mysqld-max" and create a table with the BDB storage engine:

>\mysql\bin\mysqladmin -u root -pretneciyf shutdown

>\mysql\bin\mysqld-max

>\mysql\bin\mysql -u dev -piyf fyi

mysql> CREATE TABLE fyi_bdb (
  id INTEGER PRIMARY KEY,
  title VARCHAR(80), 
  count INTEGER )
  ENGINE = BDB;
Query OK, 0 rows affected, 1 warning (0.07 sec)

mysql> SHOW CREATE TABLE fyi_bdb;
  CREATE TABLE `fyi_bdb` (
  `id` int(11) NOT NULL,
  `title` varchar(80) default NULL,
  `count` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=latin1 
1 row in set (0.02 sec)

mysql> INSERT INTO fyi_bdb (id) VALUES(-1);
Query OK, 1 row affected (0.05 sec)

⇒ Data File of BDB Storage Engine in MySQL

⇐ Tables Using BDB Storage Engine in MySQL

⇑ Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇑⇑ MySQL Database Tutorials