MySQL Forums
Forum List  »  Data Recovery

MySQL FRM & Data Recovery: Articles, Blogs
Posted by: Edwin DeSouza
Date: December 17, 2007 05:57PM

MySQL Internals File Formats
http://dev.mysql.com/doc/internals/en/fileformats.html
- ".frm" file contains table definition
- ".MYI" contains info about index
- ".MYD" contains data

Beyond the FRM:
- http://www.tocker.ca/2014/07/30/beyond-the-frm-ideas-for-a-native-mysql-data-dictionary.html


MySQL Utilities: FRM Reader
- Download: http://dev.mysql.com/downloads/tools/utilities/
- Docs: http://dev.mysql.com/doc/workbench/en/mysqlfrm.html
- http://drcharlesbell.blogspot.com/2013/04/mysql-utilities-new-frm-reader-utility.html
- http://mysqlblog.fivefarmers.com/2013/04/09/mysql-utilities-meets-the-worlds-ugliest-table/
- http://www.mysqlperformanceblog.com/2014/01/02/recover-table-structure-frm-files-mysql-utilities/



dbSake, frmDump for MySQL:
- https://dbsake.readthedocs.io/en/latest/
- https://dbsake.readthedocs.io/en/latest/commands/frmdump.html
- https://www.percona.com/blog/2015/12/16/recovering-table-structure-from-frm-files-using-dbsake/


Recovering CREATE TABLE statement from .frm file:
- https://twindb.com/how-to-recover-table-structure-from-frm-files-online/
- http://www.mysqlperformanceblog.com/2008/12/17/recovering-create-table-statement-from-frm-file/
- https://www.percona.com/blog/2015/07/09/obtain-mysql-version-frm-file/

Recovering an InnoDB table:
- http://www.mysqlperformanceblog.com/2013/04/22/how-to-recover-table-structure-from-innodb-dictionary/
- http://www.mysqlperformanceblog.com/2011/06/03/a-recovery-trivia-or-how-to-recover-from-a-lost-ibdata1-file/
- http://www.bluegecko.net/mysql/recovering-a-schema-from-innodb-frm-files/
- http://www.fromdual.com/recover-lost-frm-files-for-innodb-tables
- http://www.chriscalender.com/?p=28
- https://twindb.com/recover-innodb-table-after-drop-table-innodb/
- https://twindb.com/how-to-recover-innodb-dictionary/
- https://launchpad.net/undrop-for-innodb

InnoDB Transportable Tablespaces - Recovering Data from Stranded .ibd Files is a Thing of the Past
- http://www.mysqlperformanceblog.com/2013/11/05/how-to-recover-an-orphaned-ibd-file-with-mysql-5-6/
- http://www.chriscalender.com/?p=1078

InnoDB Transportable Tablespaces:
- http://mysqlblog.fivefarmers.com/2012/11/07/smarter-innodb-transportable-tablespace-management-operations/
- http://mysqlblog.fivefarmers.com/2012/09/07/understanding-innodb-transportable-tablespaces-in-mysql-5-6/
- https://blogs.oracle.com/mysqlinnodb/entry/innodb_transportable_tablespaces

TwinDB Toolkit: Restore data from InnoDB file (idb & frm)
- http://thelazylog.com/restore-data-from-innodb-file-idb-frm/

Hacking FRM files to switch data types
- http://www.facebook.com/note.php?note_id=10150115679045933


FRM blogs:
- http://jan.kneschke.de/2008/8/2/mysql-internals-screens-or-frm-files/
- http://www.flamingspork.com/blog/2009/02/15/the-frm-file-format/
- http://www.mysqlperformanceblog.com/2013/04/08/understanding-the-maximum-number-of-columns-in-a-mysql-table/
- http://sheeri.com/content/unireg-and-automatic-database-ui-generatio
- http://blogs.sun.com/thava/entry/dump_mysql_frm_file_header


FRM Scripts
- Python: http://code.google.com/p/mysql-replace-tables-live/
- Python: http://code.google.com/p/mysql-replace-tables-live/wiki/Documentation
- Python: http://code.google.com/p/mysql-replace-tables-live/source/browse/trunk/mysql_replace_tables_live.py
- Perl: http://blogs.sun.com/thava/entry/dump_mysql_frm_file_header#comment-1224853690000
- Perl: http://www.bluegecko.net/recover_schema-pl/
- PHP: http://blogs.sun.com/thava/resource/frmdump
- C: http://bazaar.launchpad.net/~mysql-proxy-developers/mysql-proxy/0.8/view/head:/src/mysql-myisam-dump.c



Edited 29 time(s). Last edit at 12/04/2018 10:21PM by Edwin Desouza.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL FRM & Data Recovery: Articles, Blogs
13435
December 17, 2007 05:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.