Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Where Table Data Is Stored by the BDB Storage Engine
Where Table Data Is Stored by the BDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: FYIcenter.com
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
2007-05-10, 4704👍, 0💬
Popular Posts:
Example of using Regular Expressions for syntax checking in JavaScript ... var re = new RegExp("^(&a...
How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce a...
What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML ...
How To Enter Numeric Values as HEX Numbers? - MySQL FAQs - Introduction to SQL Basics If you want to...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...