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.