{"id":8202,"date":"2023-08-17T11:29:07","date_gmt":"2023-08-17T11:29:07","guid":{"rendered":"https:\/\/www.cigatisolutions.com\/blog\/?p=8202"},"modified":"2024-04-17T05:38:31","modified_gmt":"2024-04-17T05:38:31","slug":"recover-mysql-database-from-frm-and-ibd-files","status":"publish","type":"post","link":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/","title":{"rendered":"Recover MySQL Database from FRM and IBD Files &#8211; Easy Tips"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;8202&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Recover MySQL Database from FRM and IBD Files - Easy Tips&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (2 votes)    <\/div>\n    <\/div>\n<p>Losing access to your MySQL database can be a nightmare, but fear not! There&#8217;s a way to recover your valuable data using the FRM and IBD files. These files hold the structure and actual information of your database. In this guide, we&#8217;ll walk you through the best way to recover MySQL Database from FRM and IBD Files step by step. In fact, you can directly use <a href=\"https:\/\/www.cigatisolutions.com\/mysql-database-repair\/\"><strong>Cigati MySQL Database Repair Tool<\/strong><\/a> to recover corruption.<\/p>\n<div class=\"text-center\"><a href=\"https:\/\/www.cigatisolutions.com\/demo-version\/cigati-mysql-database-repair.exe\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone my-3 wp-image-4130 size-full\" src=\"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2021\/11\/downlad-btn-new.png\" alt=\"Download Now\" width=\"163\" height=\"40\" \/><\/a>\u00a0 \u00a0 <a href=\"https:\/\/www.cigatisolutions.com\/mysql-database-repair\/purchase-now.php\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone my-3 wp-image-4129 size-full\" src=\"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2021\/11\/buy-btn-new.png\" alt=\"Buy Now\" width=\"163\" height=\"40\" \/><\/a><\/div>\n<p>FRM files contain the structure and definition of your database tables, while IBD files store the actual data, such as your usernames, passwords, etc. FRM files hold the plans for how your tables should look. When you lose access to your MySQL database, these files can become your lifeline to restoring your data.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#Why_Restore_Tables_Data_from_the_FRM_and_IBD_Files\" >Why Restore Tables Data from the FRM and IBD Files?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#How_to_Recover_MySQL_Database_from_FRM_and_IBD_Files\" >How to Recover MySQL Database from FRM and IBD Files?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#Stage_1_Create_MySQL_Databases_to_Recreate_the_Table\" >Stage 1: Create MySQL Databases to Recreate the Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#Stage_2_Search_For_The_Table_Schema\" >Stage 2: Search For The Table Schema<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#Stage_3_Create_a_New_FRM_and_IBD_Files\" >Stage 3: Create a New .FRM and .IBD Files<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#Stage_4_Delete_The_Newly_ibd_File\" >Stage 4: Delete The Newly .ibd File<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#Stage_5_Import_Tablespace_in_MySQL\" >Stage 5: Import Tablespace in MySQL<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#Final_Thoughts\" >Final Thoughts<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Why_Restore_Tables_Data_from_the_FRM_and_IBD_Files\"><\/span>Why Restore Tables Data from the FRM and IBD Files?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>So, now the question arises regarding why you need to recover your database using these files. Well, think about all the stuff you&#8217;ve stored inside your database. Losing information could be a big problem! There are possible reasons that will highlight the common reasons for that.<\/p>\n<ul class=\"list_content\">\n<li>You might accidentally delete some valuable data from your database.<\/li>\n<li>Sometimes, hiccups make things go missing. Your data might disappear due to these hiccups.<\/li>\n<li>Database upgrades play tricks, and your data might vanish during the process.<\/li>\n<li>Power failures, while your database is working, can cause your treasures to vanish too.<\/li>\n<li>Sometimes, hackers might target your database, making your data disappear.<\/li>\n<li>Moving your database to a new computer or server leads to data loss.<\/li>\n<li>Changing database settings based on advice can lead to lost data too.<\/li>\n<\/ul>\n<p>Here are some common reasons to Restore Data from the FRM and IBD Files. Now, we\u2019ll move further to get to know the possible way for the same.<\/p>\n<p><strong>Also Read:<\/strong> <a href=\"https:\/\/www.cigatisolutions.com\/blog\/mysql-shutdown-unexpectedly-error\/\">MySQL Shutdown Unexpectedly<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Recover_MySQL_Database_from_FRM_and_IBD_Files\"><\/span>How to Recover MySQL Database from FRM and IBD Files?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before starting any recovery process, it&#8217;s essential to back up your existing FRM and IBD files. It ensures you have a safety net in case anything goes wrong during the recovery process. The following section has several stages to Recover the Database from FRM and IBD Files. You just need to check them out.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Stage_1_Create_MySQL_Databases_to_Recreate_the_Table\"><\/span>Stage 1: Create MySQL Databases to Recreate the Table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We&#8217;ll use a tool, phpMyAdmin, to do this.<\/p>\n<ul>\n<li>To start, you need to log in to phpMyAdmin.<\/li>\n<li>In the &#8220;Create database&#8221; section, assign a name to your database. Then, tap the &#8220;Create&#8221; button.<\/li>\n<li>You&#8217;ve got a brand-new database, employee.<\/li>\n<li>Find your MySQL database where it is located.<\/li>\n<li>The database doesn&#8217;t have all its tables &#8211; .FRM and .IBD files yet.<\/li>\n<li>You step into the &#8220;employee&#8221; database and get no tables.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Stage_2_Search_For_The_Table_Schema\"><\/span>Stage 2: Search For The Table Schema<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Let&#8217;s dive to help you to rescue lost table plans for your MySQL database. If you have a table schema, skip ahead.<\/p>\n<ul>\n<li>Download MySQL Utilities.<\/li>\n<li>Mysqlfrm is a tool that can save the day by bringing back lost table blueprints.<\/li>\n<li>Then, you mention the Mysqlfrm tool to find your missing table plan. Here is the command you need to say:<\/li>\n<\/ul>\n<p><span style=\"background-color: #d3d3d3;\"><em>mysql.FRM \u2013diagnostic path filename.frm path<\/em><\/span><\/p>\n<ul>\n<li>After that, you can see some parts of the table structure again.<\/li>\n<li>You can use the above command to restore FRM files, but it can&#8217;t recover everything.<\/li>\n<li>Opt for this command to rescue information from your FRM files:<\/li>\n<\/ul>\n<p><span style=\"background-color: #d3d3d3;\"><em>mysqlfrm \u2013server=root@127.0.0.1 \u2013port 3307 .\/filename.frm<\/em><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Stage_3_Create_a_New_FRM_and_IBD_Files\"><\/span>Stage 3: Create a New .FRM and .IBD Files<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Alright, let&#8217;s add a new table to your database. You open the database file and add a script used in the above section for the table. Now, you have a new table.FRM and .IBD files, ready to store and organize your data.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Stage_4_Delete_The_Newly_ibd_File\"><\/span>Stage 4: Delete The Newly .ibd File<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Follow this command to remove the newly created.IDB file:<\/li>\n<\/ul>\n<p><span style=\"background-color: #d3d3d3;\"><em>ALTER TABLE table_name DISCARD TABLESPACE<\/em><\/span><\/p>\n<ul>\n<li>It will successfully split the link between MySQL and the tablespace to delete the .IBD file.<\/li>\n<li>Now, copy the actual .IBD file in the new Database.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Stage_5_Import_Tablespace_in_MySQL\"><\/span>Stage 5: Import Tablespace in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Now, you can recreate the connection between the MySQL table and tablespace. After the completion process of the actual .IBD file, follow the below command:<\/p>\n<p><span style=\"background-color: #d3d3d3;\"><em>ALTER TABLE table_name IMPORT TABLESPACE<\/em>;<\/span><\/p>\n<p>Here is the solution to Recover MySQL Database from FRM and IBD Files. If you are still facing multiple problems in your My SQL application, it simply indicates your database is severely damaged. If you want to repair your corrupted or inaccessible FRM and IBD files, opt for the <strong>Cigati My SQL Database Repair Tool<\/strong>. It will recover corruption from your damaged files without data loss.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Final_Thoughts\"><\/span>Final Thoughts<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Don&#8217;t worry if your MySQL database disappears! With this guide, you can get it back using FRM and IBD files. The above procedure helps you to Recover MySQL Database from FRM and IBD Files. Moreover, it also helps you put your valuable information back where it belongs.<\/p>\n\n\n<p><strong>You May Also Read:<\/strong> <a href=\"https:\/\/www.cigatisolutions.com\/blog\/mysql-is-marked-as-crashed-and-should-be-repaired\/\">MySQL is Marked as Crashed and Should be Repaired<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Losing access to your MySQL database can be a nightmare, but fear not! There&#8217;s a way to recover your valuable<a class=\"read-more ml-1 main-read-more\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/\">Read More<\/a><\/p>\n","protected":false},"author":15,"featured_media":8204,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-8202","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-recovery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Recover MySQL Database from FRM and IBD Files - Easy Tips<\/title>\n<meta name=\"description\" content=\"If your MySQL database is lost or damaged, this guide will teach you how to recover your data from FRM and IBD files.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recover MySQL Database from FRM and IBD Files - Easy Tips\" \/>\n<meta property=\"og:description\" content=\"If your MySQL database is lost or damaged, this guide will teach you how to recover your data from FRM and IBD files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/\" \/>\n<meta property=\"og:site_name\" content=\"Cigati Solutions Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-17T11:29:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-17T05:38:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2023\/08\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png\" \/>\n\t<meta property=\"og:image:width\" content=\"698\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Saumya Tandon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Saumya Tandon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/\"},\"author\":{\"name\":\"Saumya Tandon\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/f936a0de52cb9c25112229b2618f51d5\"},\"headline\":\"Recover MySQL Database from FRM and IBD Files &#8211; Easy Tips\",\"datePublished\":\"2023-08-17T11:29:07+00:00\",\"dateModified\":\"2024-04-17T05:38:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/\"},\"wordCount\":846,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png\",\"articleSection\":[\"Data Recovery\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/\",\"name\":\"Recover MySQL Database from FRM and IBD Files - Easy Tips\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png\",\"datePublished\":\"2023-08-17T11:29:07+00:00\",\"dateModified\":\"2024-04-17T05:38:31+00:00\",\"description\":\"If your MySQL database is lost or damaged, this guide will teach you how to recover your data from FRM and IBD files.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png\",\"contentUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png\",\"width\":698,\"height\":400,\"caption\":\"Recover MySQL Database from FRM and IBD Files\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/recover-mysql-database-from-frm-and-ibd-files\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recover MySQL Database from FRM and IBD Files &#8211; Easy Tips\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/\",\"name\":\"Cigati Solutions Blog\",\"description\":\"Technical Tips &amp; Tricks of Data Migration\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#organization\",\"name\":\"Cigati Solutions Blog\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png\",\"contentUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png\",\"width\":182,\"height\":72,\"caption\":\"Cigati Solutions Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/f936a0de52cb9c25112229b2618f51d5\",\"name\":\"Saumya Tandon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba431baf37cf75fc172254e2cb7d589bcc5b2251e49e715cf38119f2d5514138?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba431baf37cf75fc172254e2cb7d589bcc5b2251e49e715cf38119f2d5514138?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba431baf37cf75fc172254e2cb7d589bcc5b2251e49e715cf38119f2d5514138?s=96&d=mm&r=g\",\"caption\":\"Saumya Tandon\"},\"description\":\"Saumya is a proficient technical content writer with a deep passion for technology and a natural talent for writing. She excels in creating compelling and informative content that captivates readers on technology websites. Her areas of specialization include data migration, Email backup, and recovery, where her vast expertise enables her to develop superior-quality content that is both educational and stimulating.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/saumya-tandon-0b2572242\\\/\"],\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/author\\\/saumya123\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Recover MySQL Database from FRM and IBD Files - Easy Tips","description":"If your MySQL database is lost or damaged, this guide will teach you how to recover your data from FRM and IBD files.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/","og_locale":"en_US","og_type":"article","og_title":"Recover MySQL Database from FRM and IBD Files - Easy Tips","og_description":"If your MySQL database is lost or damaged, this guide will teach you how to recover your data from FRM and IBD files.","og_url":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/","og_site_name":"Cigati Solutions Blog","article_published_time":"2023-08-17T11:29:07+00:00","article_modified_time":"2024-04-17T05:38:31+00:00","og_image":[{"width":698,"height":400,"url":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2023\/08\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png","type":"image\/png"}],"author":"Saumya Tandon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Saumya Tandon","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#article","isPartOf":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/"},"author":{"name":"Saumya Tandon","@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/person\/f936a0de52cb9c25112229b2618f51d5"},"headline":"Recover MySQL Database from FRM and IBD Files &#8211; Easy Tips","datePublished":"2023-08-17T11:29:07+00:00","dateModified":"2024-04-17T05:38:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/"},"wordCount":846,"publisher":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2023\/08\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png","articleSection":["Data Recovery"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/","url":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/","name":"Recover MySQL Database from FRM and IBD Files - Easy Tips","isPartOf":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#primaryimage"},"image":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2023\/08\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png","datePublished":"2023-08-17T11:29:07+00:00","dateModified":"2024-04-17T05:38:31+00:00","description":"If your MySQL database is lost or damaged, this guide will teach you how to recover your data from FRM and IBD files.","breadcrumb":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#primaryimage","url":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2023\/08\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png","contentUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2023\/08\/Recover-MySQL-Database-from-FRM-and-IBD-Files-Easy-Tips.png","width":698,"height":400,"caption":"Recover MySQL Database from FRM and IBD Files"},{"@type":"BreadcrumbList","@id":"https:\/\/www.cigatisolutions.com\/blog\/recover-mysql-database-from-frm-and-ibd-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cigatisolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Recover MySQL Database from FRM and IBD Files &#8211; Easy Tips"}]},{"@type":"WebSite","@id":"https:\/\/www.cigatisolutions.com\/blog\/#website","url":"https:\/\/www.cigatisolutions.com\/blog\/","name":"Cigati Solutions Blog","description":"Technical Tips &amp; Tricks of Data Migration","publisher":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cigatisolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.cigatisolutions.com\/blog\/#organization","name":"Cigati Solutions Blog","url":"https:\/\/www.cigatisolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2018\/12\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png","contentUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2018\/12\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png","width":182,"height":72,"caption":"Cigati Solutions Blog"},"image":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/person\/f936a0de52cb9c25112229b2618f51d5","name":"Saumya Tandon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ba431baf37cf75fc172254e2cb7d589bcc5b2251e49e715cf38119f2d5514138?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ba431baf37cf75fc172254e2cb7d589bcc5b2251e49e715cf38119f2d5514138?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ba431baf37cf75fc172254e2cb7d589bcc5b2251e49e715cf38119f2d5514138?s=96&d=mm&r=g","caption":"Saumya Tandon"},"description":"Saumya is a proficient technical content writer with a deep passion for technology and a natural talent for writing. She excels in creating compelling and informative content that captivates readers on technology websites. Her areas of specialization include data migration, Email backup, and recovery, where her vast expertise enables her to develop superior-quality content that is both educational and stimulating.","sameAs":["https:\/\/www.linkedin.com\/in\/saumya-tandon-0b2572242\/"],"url":"https:\/\/www.cigatisolutions.com\/blog\/author\/saumya123\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=8202"}],"version-history":[{"count":5,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8202\/revisions"}],"predecessor-version":[{"id":9319,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8202\/revisions\/9319"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/media\/8204"}],"wp:attachment":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=8202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=8202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=8202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}