(mysql.info) bdb-restrictions
Info Catalog
(mysql.info) bdb-todo
(mysql.info) bdb-storage-engine
(mysql.info) bdb-errors
14.5.6 Restrictions on `BDB' Tables
-----------------------------------
The following list indicates restrictions that you must observe when
using `BDB' tables:
* Each `BDB' table stores in its `.db' file the path to the file as
it was created. This is done to enable detection of locks in a
multi-user environment that supports symlinks. As a consequence of
this, it is not possible to move `BDB' table files from one
database directory to another.
* When making backups of `BDB' tables, you must either use
`mysqldump' or else make a backup that includes the files for each
`BDB' table (the `.frm' and `.db' files) as well as the `BDB' log
files. The `BDB' storage engine stores unfinished transactions in
its log files and requires them to be present when `mysqld'
starts. The `BDB' logs are the files in the data directory with
names of the form `log.NNNNNNNNNN' (ten digits).
* If a column that allows `NULL' values has a unique index, only a
single `NULL' value is allowed. This differs from other storage
engines, which allow multiple `NULL' values in unique indexes.
Info Catalog
(mysql.info) bdb-todo
(mysql.info) bdb-storage-engine
(mysql.info) bdb-errors
automatically generated byinfo2html