Data File of BDB Storage Engine in MySQL

Q

Where Table Data Is Stored by the BDB Storage Engine in MySQL?

✍: FYIcenter.com

A

By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, the BDB storage engine will create one file for each table to store table data and index data.

If a new table is created with the BDB storage engine, one format file named as databaseName\tableName.frm will be created. Another file named as databaseName\tableName.db to store table data and index data. For example, the new table "fyi_bdb" created in the previous tutorial exercise will result the following files:

>cd \mysql\data

>dir fyi\fyi_bdb.*
   49,152 fyi_bdb.db
    8,620 fyi_bdb.frm

 

Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇒⇒MySQL Database Tutorials

2017-08-13, 289👍, 0💬