IBD File Extension

What is IBD file?

Files with .IBD extension store MySQL InnoDB database tables information regarding indexing and table structure. MySQL InnoDB Database Table files can hold shared tablespace for multiple tables and indexes where the name of IBD files is defined by the tablespace and with unique ID number. Tables can be created using one-to-one mapping (file-to-table) with the file name corresponding to the table name. This is the default method in InnoDB.

IBD files structure - Database Table

IBD files contain pages of defined size. IBD is a binary format and is divide into several types with defined roles, such as:

• HEADER PAGE - page 0 containing header and metadata,
• EXTENTS - multiple pages containing data,
• XDES PAGE - EXTENT DESCRIPTOR PAGE - a page describing contents of EXTENTS pages,
• INODE PAGE - page containing File Segments information.

IBD files have complex structure and should be opened using dedicated tools. IBD standard supports encryption.

Support for InnoBD IBD files

InnoBD MySQL-specific IBD format is only supported by InnoDB. IBD files can also be used to crate database table data backup copies. Importing IBD data to other databases requires that CFG metadata file and CFP file - if the database is encrypted - is imported as well.

Programs which support IBD file extension

Programs that can handle IBD files are as follows. Files with IBD suffix can be copied to any mobile device or system platform, but it may not be possible to open them properly on target system.

Updated: 05/13/2023

How to open file with IBD extension?

Being unable to open files with IBD extension can be have various origins. What is important, all common issues related to files with IBD extension can be resolved by the users themselves. The process is quick and doesn’t involve an IT expert. We have prepared a listing of which will help you resolve your problems with IBD files.

Step 1. Install MySQL Enterprise Backup software

Problems with opening and working with IBD files are most probably having to do with no proper software compatible with IBD files being present on your machine. This issue can be addressed by downloading and installing MySQL Enterprise Backup or different compatible program, such as MySQL, MySQL Enterprise Edition. Above you will find a complete listing of programs that support IBD files, classified according to system platforms for which they are available. One of the most risk-free method of downloading software is using links provided by official distributors. Visit MySQL Enterprise Backup website and download the installer.

Step 2. Check the version of MySQL Enterprise Backup and update if needed

If you already have MySQL Enterprise Backup installed on your systems and IBD files are still not opened properly, check if you have the latest version of the software. Sometimes software developers introduce new formats in place of that already supports along with newer versions of their applications. The reason that MySQL Enterprise Backup cannot handle files with IBD may be that the software is outdated. The latest version of MySQL Enterprise Backup should support all file formats that where compatible with older versions of the software.

Step 3. Set the default application to open IBD files to MySQL Enterprise Backup

After installing MySQL Enterprise Backup (the most recent version) make sure that it is set as the default application to open IBD files. The method is quite simple and varies little across operating systems.

Change the default application in Windows

• Right-click the IBD file and choose Open with option
• Next, select the Choose another app option and then using More apps open the list of available applications
• Finally select Look for another app on this PC, point to the folder where MySQL Enterprise Backup is installed, check the Always use this app to open IBD files box and conform your selection by clicking OK button

Change the default application in Mac OS

• Right-click the IBD file and select Information
• Find the Open with option – click the title if its hidden
• Select MySQL Enterprise Backup and click Change for all...
• Finally, a This change will be applied to all files with IBD extension message should pop-up. Click Continue button in order to confirm your choice.

Step 4. Check the IBD for errors

If you followed the instructions form the previous steps yet the issue is still not solved, you should verify the IBD file in question. Being unable to access the file can be related to various issues.

1. Verify that the IBD in question is not infected with a computer virus

If the IBD is indeed infected, it is possible that the malware is blocking it from opening. It is advised to scan the system for viruses and malware as soon as possible or use an online antivirus scanner. IBD file is infected with malware? Follow the steps suggested by your antivirus software.

2. Check whether the file is corrupted or damaged

If you obtained the problematic IBD file from a third party, ask them to supply you with another copy. It is possible that the file has not been properly copied to a data storage and is incomplete and therefore cannot be opened. If the IBD file has been downloaded from the internet only partially, try to redownload it.

3. Verify whether your account has administrative rights

Some files require elevated access rights to open them. Switch to an account that has required privileges and try opening the MySQL InnoDB Database Table file again.

4. Make sure that the system has sufficient resources to run MySQL Enterprise Backup

If the systems has insufficient resources to open IBD files, try closing all currently running applications and try again.

5. Verify that your operating system and drivers are up to date

Regularly updated system, drivers, and programs keep your computer secure. This may also prevent problems with MySQL InnoDB Database Table files. It may be the case that the IBD files work properly with updated software that addresses some system bugs.

Do you want to help?

If you have additional information about the IBD file, we will be grateful if you share it with our users. To do this, use the form here and send us your information on IBD file.