Starting mysqld to Support BDB Storage Engine in MySQL

Q

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

✍: FYIcenter.com

A

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)

 

Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇒⇒MySQL Database Tutorials

2017-08-13, 331👍, 0💬