Open .IBD file with MySQL

• Import .IBD files to MySQL
• Open .IBD files from phpMyAdmin
• How to open .IBD files?

SOLUTION:

You will need to know the exact structure of the table (CREATE TABLE statement).

1. Create the table with the same structure.
2. Execute SQL query: ALTER TABLE table_name DISCARD TABLESPACE;
3. Copy the file ibd table_name.ibd into your /data/database_name/ directory
4. Execute SQL query: ALTER TABLE table_name IMPORT TABLESPACE;

NOTE: We recommend performing: FLUSH TABLE table_name in step 2, in case of importing a table with existing information. it does not work with tables that have records.

Commentary

Comments