Collections:
Starting mysqld to Support BDB Storage Engine in MySQL
How To Start mysqld to Support the BDB Storage Engine in MySQL?
✍: FYIcenter.com
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
2017-08-13, 1582🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...