DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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