Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Start mysqld to Support the BDB Storage Engine
How To Start mysqld to Support the BDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: 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)
2007-05-10, 4474👍, 0💬
Popular Posts:
How To Build WHERE Criteria with Web Form Search Fields? - MySQL FAQs - Managing Tables and Running ...
What is Shell scripting A shell script is a script written for the shell, or command line interprete...
What is normalization? What are different types of normalization? It is set of rules that have been ...
What Is the Difference between Formal Parameters and Actual Parameters? - Oracle DBA FAQ - Creating ...
How can you check to see whether a symbol is defined? You can use the #ifdef and #ifndef preprocesso...