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, 4536👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred? - MySQL FAQs - Transaction Management: C...
Can you explain Forms authentication in detail ? In old ASP if you where said to create a login page...
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you...
How To Export Data to an XML File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you wa...