--- title: How to Extract Data from InnoDB, MyISAM, and MyRocks... description: Innodump is a new open-source tool that extracts data from InnoDB, MyISAM, and MyRocks files without a running MySQL or MariaDB server. It reads raw data... canonical: https://daily.dev/posts/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-bqvsgrqrn twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server | daily.dev og:description: Innodump is a new open-source tool that extracts data from InnoDB, MyISAM, and MyRocks files without a running MySQL or MariaDB server. It reads raw data... og:url: https://daily.dev/posts/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-bqvsgrqrn og:image: https://api.daily.dev/og/posts/bQVSGrqRN.png og:image:alt: How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server **[Percona Blog](https://daily.dev/sources/percona)** · 6 min read · 0 upvotes · 0 comments ## Summary Innodump is a new open-source tool that extracts data from InnoDB, MyISAM, and MyRocks files without a running MySQL or MariaDB server. It reads raw data files, data directories, or binary backups, which helps when a server has crashed due to corrupted pages. A '--skip-corrupted' option skips damaged pages to recover as much data as possible, and '--examine' reports how many rows are readable versus corrupted. Other options include '--deleted-only' for recovering delete-marked rows, plus '--io-limit' and '--direct-io' to throttle exports from live production systems. The author built it with the help of vibe-coding and notes it is an experimental personal project, not official Percona software. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How can I recover data from a corrupted InnoDB table when MySQL crashes every time I query it? Use innodump, an open-source tool that reads InnoDB, MyISAM, and MyRocks data files directly without running a MySQL server. Its '--skip-corrupted' option skips damaged pages and continues reading, letting you extract all healthy rows instead of restarting the server after every crash caused by a corrupted page. _Recovering from database corruption? daily.dev surfaces tools and writeups like this for your incident playbook._ ### Can I recover deleted rows from an InnoDB table space after a DELETE statement? Yes, often you can, because InnoDB only delete-marks rows instead of immediately purging or overwriting them in the tablespace. If no new writes have reclaimed that space yet, those rows can usually still be decoded. The innodump tool exposes a '--deleted-only' option specifically for recovering these delete-marked rows. _Chasing accidental deletes? daily.dev tracks database recovery techniques like this one for when disaster strikes._ ### How do I pull a staging database snapshot from a live production MySQL server without impacting performance? Limit IO throughput and bypass the OS page cache while exporting. The innodump tool supports '--io-limit' to set a rate in bytes per second and '--direct-io' to use the O_DIRECT flag, avoiding cache trashing and memory pressure; running it with 'nice' further reduces CPU impact on the live server. _Need staging data without hammering production? daily.dev collects practical ops techniques like throttled exports._ ## Similar posts on daily.dev - [Analyzing Aurora MySQL issues with Kiro IDE and Aurora MySQL MCP server](https://daily.dev/posts/analyzing-aurora-mysql-issues-with-kiro-ide-and-aurora-mysql-mcp-server-lzpvxyy8k) · AWS Database Blog · 0 upvotes · 0 comments - [How to Inspect a pg\_dump Without Restoring It](https://daily.dev/posts/how-to-inspect-a-pg-dump-without-restoring-it-g8bkw9m30) · Planet PostgreSQL · 0 upvotes · 0 comments - [DuckDB Speed on MySQL with dbtrail, Without a New Storage Engine](https://daily.dev/posts/duckdb-speed-on-mysql-with-dbtrail-without-a-new-storage-engine-0gt0zkgml) · Planet MySQL · 1 upvotes · 0 comments - [Free Data Explorer for MySQL and PostgreSQL Migration Checks](https://daily.dev/posts/free-data-explorer-for-mysql-and-postgresql-migration-checks-fxnyxwl2r) · DBconvert · 0 upvotes · 0 comments - [Same Job, Two Engines: InnoDB and Iceberg Internals](https://daily.dev/posts/same-job-two-engines-innodb-and-iceberg-internals-2fsggpsen) · Hacker News · 0 upvotes · 0 comments --- Tags: [#infrastructure](https://daily.dev/tags/infrastructure), [#mysql](https://daily.dev/tags/mysql) [View this post on daily.dev](https://daily.dev/posts/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-bqvsgrqrn) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server","url":"https://daily.dev/posts/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-bqvsgrqrn","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-bqvsgrqrn"},"datePublished":"2026-10-28T13:58:32.440Z","dateModified":"2026-10-28T15:01:44.736Z","description":"Innodump is a new open-source tool that extracts data from InnoDB, MyISAM, and MyRocks files without a running MySQL or MariaDB server. It reads raw data...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/e7959db81b8788988142f98a25ca385c?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/e7959db81b8788988142f98a25ca385c?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Percona Blog","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Percona Blog","logo":"https://media.daily.dev/image/upload/s--Lb3XkBh3--/f_auto,q_auto/v1780213412/logos/percona?_a=BAMAMiWQ0","url":"https://daily.dev/sources/percona"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-bqvsgrqrn","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"infrastructure,mysql","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Percona Blog","item":"https://daily.dev/sources/percona"},{"@type":"ListItem","position":3,"name":"How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-bqvsgrqrn#faq","mainEntity":[{"@type":"Question","name":"How can I recover data from a corrupted InnoDB table when MySQL crashes every time I query it?","acceptedAnswer":{"@type":"Answer","text":"Use innodump, an open-source tool that reads InnoDB, MyISAM, and MyRocks data files directly without running a MySQL server. Its '--skip-corrupted' option skips damaged pages and continues reading, letting you extract all healthy rows instead of restarting the server after every crash caused by a corrupted page. Recovering from database corruption? daily.dev surfaces tools and writeups like this for your incident playbook."}},{"@type":"Question","name":"Can I recover deleted rows from an InnoDB table space after a DELETE statement?","acceptedAnswer":{"@type":"Answer","text":"Yes, often you can, because InnoDB only delete-marks rows instead of immediately purging or overwriting them in the tablespace. If no new writes have reclaimed that space yet, those rows can usually still be decoded. The innodump tool exposes a '--deleted-only' option specifically for recovering these delete-marked rows. Chasing accidental deletes? daily.dev tracks database recovery techniques like this one for when disaster strikes."}},{"@type":"Question","name":"How do I pull a staging database snapshot from a live production MySQL server without impacting performance?","acceptedAnswer":{"@type":"Answer","text":"Limit IO throughput and bypass the OS page cache while exporting. The innodump tool supports '--io-limit' to set a rate in bytes per second and '--direct-io' to use the O_DIRECT flag, avoiding cache trashing and memory pressure; running it with 'nice' further reduces CPU impact on the live server. Need staging data without hammering production? daily.dev collects practical ops techniques like throttled exports."}}]} ```