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.