The following list indicates restrictions that you must observe
BDBtable stores in its
.dbfile 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
BDBtable files from one database directory to another.
When making backups of
BDBtables, you must either use mysqldump or else make a backup that includes the files for each
.dbfiles) as well as the
BDBlog files. The
BDBstorage engine stores unfinished transactions in its log files and requires them to be present when mysqld starts. The
BDBlogs are the files in the data directory with names of the form
If a column that permits
NULLvalues has a unique index, only a single
NULLvalue is permitted. This differs from other storage engines, which permit multiple
NULLvalues in unique indexes.