FileInfo
extension

IBD File - What is an .ibd file and how do I open it?

Learn about .IBD files and view a list of programs that open them.

Languages

EN

Overview

What is an IBD file? An IBD file is a MySQL table created by the InnoDB database engine. It contains a table-specific tablespace and index data. IBD files are created when MySQL's innodb_file_per_table option is enabled, which it is by default.

More Information MySQL is a popular open-source database management system. InnoDB is the default database engine that MySQL uses to create, update, and otherwise manage table-based data. In most instances of MySQL, InnoDB saves users' tables in individual files, which are saved with the .ibd extension. IBD files are often encrypted , meaning their data can be accessed only using the keys generated when a user created the database that created the IBD file. However, MySQL users can use IBD files to import even encrypted tables into other MySQL databases. When using an IBD file to import a table, you must also import the table's associated .CFG metadata file and, if the table is encrypted, CFP file, which InnoDB creates when you use the FLUSH TABLES FOR EXPORT command.

Popularity3.5/5

4 votes

Quick AppUsed by
VerifiedVerified by FileInfo.com The FileInfo.com team has independently researched the MySQL InnoDB Table file format and Mac, Windows, and Linux apps listed on this page. Our goal is 100% accuracy and we only publish information about file types that we have verified. If you would like to suggest any additions or updates to this page, please let us know .

Document Icon

Breadcrumbs

DeveloperOracle
Popularity3.5 | 4 Votes

Previous / Next

‹ .IBCH.IBDAT ›

In-Depth

.IBD File Extension

MySQL InnoDB Table

DeveloperOracle
Popularity
3.5  |  4 Votes
 

What is an IBD file?

An IBD file is a MySQL table created by the InnoDB database engine. It contains a table-specific tablespace and index data. IBD files are created when MySQL's innodb_file_per_table option is enabled, which it is by default.

More Information

MySQL is a popular open-source database management system. InnoDB is the default database engine that MySQL uses to create, update, and otherwise manage table-based data. In most instances of MySQL, InnoDB saves users' tables in individual files, which are saved with the .ibd extension.

IBD files are often encrypted , meaning their data can be accessed only using the keys generated when a user created the database that created the IBD file. However, MySQL users can use IBD files to import even encrypted tables into other MySQL databases. When using an IBD file to import a table, you must also import the table's associated .CFG metadata file and, if the table is encrypted, CFP file, which InnoDB creates when you use the FLUSH TABLES FOR EXPORT command.

How to open an IBD file

You can open an IBD file in MySQL (cross-platform) if you are using the InnoDB database engine. For example, you can use a backup IBD file to restore the table it contains if your current copy of the table has become corrupted or been deleted. For more information on how to use a backup IBD file to restore a MySQL table, refer to MySQL's official documentation.

Open over 400 file formats with File Viewer Plus . Free Download

Programs that open or reference IBD files

Sort

Pricing

Program Name

Platform

Reset

X

Windows

MySQL

Free Trial

Mac

MySQL

Free Trial

Linux

MySQL

Free Trial

Category: Database Files

Updated: May 20, 2021

FAQ

What is an IBD file?↓
An IBD file is a MySQL table created by the InnoDB database engine. It contains a table-specific tablespace and index data. IBD files are created when MySQL's innodb_file_per_table option is enabled, which it is by default.
How do I open an .ibd file?↓
You can open an IBD file in MySQL (cross-platform) if you are using the InnoDB database engine. For example, you can use a backup IBD file to restore the table it contains if your current copy of the table has become corrupted or been deleted. For more information on how to use a backup IBD file to restore a MySQL table, refer to MySQL's official documentation.

Related