Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Starting mysqld to Support BDB Storage Engine

By: FYIcenter.com

(Continued from previous topic...)

How To Start mysqld to Support the BDB Storage Engine?

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)

(Continued on next topic...)

  1. What Are Storage Engines?
  2. How To Create a New Table Using MyISAM Storage Engine?
  3. Where Table Data Is Stored by the MyISAM Storage Engine?
  4. How To Backup Tables by Copying MyISAM Table Files?
  5. How To Restore Tables by Copying MyISAM Table Files?
  6. How To Check and Repair MyISAM Tables?
  7. How To Create a New Table Using the InnoDB Storage Engine?
  8. Where Table Data Is Stored by the InnoDB Storage Engine?
  9. How To Create a New Table Using the BDB Storage Engine?
  10. How To Start mysqld to Support the BDB Storage Engine?
  11. Where Table Data Is Stored by the BDB Storage Engine?
  12. How To Create a New Table Using the CSV Storage Engine?
  13. How To Create a New Table Using the MEMORY Storage Engine?
  14. What Happens to MEMORY Tables When MySQL Server Is Stopped?
  15. How To See Which Storage Engines Are Supported in Your MySQL Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...