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.
(ten digits).
NNNNNNNNNN
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.
User Comments
Add your own comment.