Retrieving Table Structure from MySQL .ibd file on Windows.
Note: Tested solution on MySQL version 8.1 and above.
----
You can achieve this using ibd2sdi utility tool comes with MySQL.
Step 1: Go to MySQL Bin directory and open a command line.
Example: C:\Program Files\MySQL\MySQL Server 8.1\bin
Adjust above path based on MySQL version installed on your PC
Step 2: Copy your MySQL data directory to c:\Temp for safety reason.
That is copy C:\ProgramData\MySQL\MySQL Server 8.1\Data directory to C:\Temp\data
Step 3: Run the below command
C:\Program Files\MySQL\MySQL Server 8.1\bin>ibd2sdi C:\Temp\data\mydbname\mytablename.ibd
Note: Replace mydbname with your database name and mytablename with your table name.
Note: you can dump this json into a file. There are many other options you can try.
For more info: https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
You can also generate Json file from .ibd file.
Example: C:\Program Files\MySQL\MySQL Server 8.1\bin>ibd2sdi --dump-file=C:\Temp\mytablename.json C:\Temp\data\mydatabasename\mytablename.ibd
Some useful links for MySQL Crash troubleshooting:
MySQL Service stopped and unable to start
- https://docs.rackspace.com/docs/how-to-resolve-mysql-service-starting-and-stopping-unexpectedly
- After trying a lot, I concluded it's not worth spending more time on this option.
- https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
- https://www.percona.com/blog/mysql-8-frm-drop-how-to-recover-table-ddl/
------
Lesson learned take MySQL backup on a regular basis.
No comments:
Post a Comment