{"id":1315,"date":"2022-01-20T07:51:36","date_gmt":"2022-01-20T12:51:36","guid":{"rendered":"https:\/\/blog.index.pe\/?p=1315"},"modified":"2022-01-20T07:54:02","modified_gmt":"2022-01-20T12:54:02","slug":"abrir-archivo-ibd-con-mysql","status":"publish","type":"post","link":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/","title":{"rendered":"Open .IBD file with MySQL"},"content":{"rendered":"<ul class=\"wp-block-list\"><li>Import .IBD files to MySQL<\/li><li>Open .IBD files from phpMyAdmin<\/li><li>How to open .IBD files?<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SOLUTION:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You will need to know the exact structure of the table (CREATE TABLE statement).<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Create the table with the same structure.<\/li><li>Execute SQL query:\u00a0<code>ALTER TABLE table_name DISCARD TABLESPACE;<\/code><\/li><li>Copy the file ibd table_name.ibd into your \/data\/database_name\/ directory<\/li><li>Execute SQL query:\u00a0<code>ALTER TABLE table_name IMPORT TABLESPACE;<\/code><\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">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.<\/p>\n<div class=\"pvc_clear\"><\/div><p id=\"pvc_stats_1315\" class=\"pvc_stats all\" data-element-id=\"1315\" style=\"\"><i class=\"pvc-stats-icon small\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewbox=\"0 0 502 315\" preserveaspectratio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/blog.index.pe\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=\"0\" \/><\/p><div class=\"pvc_clear\"><\/div><div style=\"margin-top: 0px; margin-bottom: 0px;\" class=\"sharethis-inline-reaction-buttons\" ><\/div>","protected":false},"excerpt":{"rendered":"<p>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). Create the table with the same structure. Execute SQL query: ALTER TABLE table_name DISCARD TABLESPACE; Copy the ibd file table_name.ibd into your \/data\/database_name\/ directory 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.<\/p>","protected":false},"author":1,"featured_media":1316,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[7,102],"tags":[270,272,273,274,214,275,271],"class_list":["post-1315","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programacion","category-tutorial","tag-ibd","tag-discart","tag-import","tag-mariadb","tag-mysql","tag-phpmyadmin","tag-tablespace"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \/data\/nombre_basedatos\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Index.pe\"\/>\n\t<meta name=\"google-site-verification\" content=\"R0FyKtH7AO0qfbQs9OR3qfgr1MYDMagx3MsqEWaTZlE\" \/>\n\t<meta name=\"keywords\" content=\".ibd,discart,import,mariadb,mysql,phpmyadmin,tablespace,programacion,tutorial\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Blog de index.pe - Actualidad, Tecnologia, Redes, Internet, Webmaster\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Abrir archivo .IBD con MySQL Blog de Index.pe\" \/>\n\t\t<meta property=\"og:description\" content=\"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \/data\/nombre_basedatos\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"840\" \/>\n\t\t<meta property=\"og:image:height\" content=\"368\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2022-01-20T12:51:36+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-01-20T12:54:02+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/index.pe\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Abrir archivo .IBD con MySQL Blog de Index.pe\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \/data\/nombre_basedatos\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#article\",\"name\":\"Abrir archivo .IBD con MySQL Blog de Index.pe\",\"headline\":\"Abrir archivo .IBD con MySQL\",\"author\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/author\\\/wilder\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/blog.index.pe\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/maria-mysql.jpg\",\"width\":840,\"height\":368,\"caption\":\"Mysql .IBD\"},\"datePublished\":\"2022-01-20T07:51:36-05:00\",\"dateModified\":\"2022-01-20T07:54:02-05:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#webpage\"},\"articleSection\":\"Programacion, Tutorial, .ibd, DISCART, IMPORT, MariaDB, MySQL, phpMyAdmin, TABLESPACE\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en#listItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/blog.index.pe\\\/en\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/category\\\/programacion\\\/#listItem\",\"name\":\"Programacion\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/category\\\/programacion\\\/#listItem\",\"position\":2,\"name\":\"Programacion\",\"item\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/category\\\/programacion\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#listItem\",\"name\":\"Abrir archivo .IBD con MySQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en#listItem\",\"name\":\"Inicio\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#listItem\",\"position\":3,\"name\":\"Abrir archivo .IBD con MySQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/category\\\/programacion\\\/#listItem\",\"name\":\"Programacion\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/#organization\",\"name\":\"Blog de Index.pe\",\"description\":\"El Blog de Index.pe ofrece art\\u00edculos detallados sobre creaci\\u00f3n y gesti\\u00f3n de p\\u00e1ginas web, dominios, hosting, marketing online, WordPress, SEO, SSL y Actualidad\",\"url\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/\",\"telephone\":\"+51943643097\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/blog.index.pe\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/blog-index.png\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#organizationLogo\",\"width\":400,\"height\":400,\"caption\":\"Logo Blog de Index.pe\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/author\\\/wilder\\\/#author\",\"url\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/author\\\/wilder\\\/\",\"name\":\"Index.pe\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/144b5b7142fdf15a32e0451c3f444446e2a7e0c3c2f70ea8fca0208037d9033d?s=96&d=wavatar&r=g\",\"width\":96,\"height\":96,\"caption\":\"Index.pe\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#webpage\",\"url\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/\",\"name\":\"Abrir archivo .IBD con MySQL Blog de Index.pe\",\"description\":\"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \\\/data\\\/nombre_basedatos\\\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/author\\\/wilder\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/author\\\/wilder\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/blog.index.pe\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/maria-mysql.jpg\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#mainImage\",\"width\":840,\"height\":368,\"caption\":\"Mysql .IBD\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/abrir-archivo-ibd-con-mysql\\\/#mainImage\"},\"datePublished\":\"2022-01-20T07:51:36-05:00\",\"dateModified\":\"2022-01-20T07:54:02-05:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/\",\"name\":\"Blog de Index.pe\",\"description\":\"El Blog de Index.pe ofrece art\\u00edculos detallados sobre creaci\\u00f3n y gesti\\u00f3n de p\\u00e1ginas web, dominios, hosting, marketing online, WordPress, SEO, SSL y Actualidad\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.index.pe\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Abrir archivo .IBD con MySQL Blog de Index.pe","description":"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \/data\/nombre_basedatos\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:","canonical_url":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/","robots":"max-image-preview:large","keywords":".ibd,discart,import,mariadb,mysql,phpmyadmin,tablespace,programacion,tutorial","webmasterTools":{"google-site-verification":"R0FyKtH7AO0qfbQs9OR3qfgr1MYDMagx3MsqEWaTZlE","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#article","name":"Abrir archivo .IBD con MySQL Blog de Index.pe","headline":"Abrir archivo .IBD con MySQL","author":{"@id":"https:\/\/blog.index.pe\/en\/author\/wilder\/#author"},"publisher":{"@id":"https:\/\/blog.index.pe\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg","width":840,"height":368,"caption":"Mysql .IBD"},"datePublished":"2022-01-20T07:51:36-05:00","dateModified":"2022-01-20T07:54:02-05:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#webpage"},"isPartOf":{"@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#webpage"},"articleSection":"Programacion, Tutorial, .ibd, DISCART, IMPORT, MariaDB, MySQL, phpMyAdmin, TABLESPACE"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/blog.index.pe\/en#listItem","position":1,"name":"Inicio","item":"https:\/\/blog.index.pe\/en","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.index.pe\/en\/category\/programacion\/#listItem","name":"Programacion"}},{"@type":"ListItem","@id":"https:\/\/blog.index.pe\/en\/category\/programacion\/#listItem","position":2,"name":"Programacion","item":"https:\/\/blog.index.pe\/en\/category\/programacion\/","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#listItem","name":"Abrir archivo .IBD con MySQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/blog.index.pe\/en#listItem","name":"Inicio"}},{"@type":"ListItem","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#listItem","position":3,"name":"Abrir archivo .IBD con MySQL","previousItem":{"@type":"ListItem","@id":"https:\/\/blog.index.pe\/en\/category\/programacion\/#listItem","name":"Programacion"}}]},{"@type":"Organization","@id":"https:\/\/blog.index.pe\/en\/#organization","name":"Blog de Index.pe","description":"El Blog de Index.pe ofrece art\u00edculos detallados sobre creaci\u00f3n y gesti\u00f3n de p\u00e1ginas web, dominios, hosting, marketing online, WordPress, SEO, SSL y Actualidad","url":"https:\/\/blog.index.pe\/en\/","telephone":"+51943643097","logo":{"@type":"ImageObject","url":"https:\/\/blog.index.pe\/wp-content\/uploads\/2020\/03\/blog-index.png","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#organizationLogo","width":400,"height":400,"caption":"Logo Blog de Index.pe"},"image":{"@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/blog.index.pe\/en\/author\/wilder\/#author","url":"https:\/\/blog.index.pe\/en\/author\/wilder\/","name":"Index.pe","image":{"@type":"ImageObject","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/144b5b7142fdf15a32e0451c3f444446e2a7e0c3c2f70ea8fca0208037d9033d?s=96&d=wavatar&r=g","width":96,"height":96,"caption":"Index.pe"}},{"@type":"WebPage","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#webpage","url":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/","name":"Abrir archivo .IBD con MySQL Blog de Index.pe","description":"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \/data\/nombre_basedatos\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/blog.index.pe\/en\/#website"},"breadcrumb":{"@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#breadcrumblist"},"author":{"@id":"https:\/\/blog.index.pe\/en\/author\/wilder\/#author"},"creator":{"@id":"https:\/\/blog.index.pe\/en\/author\/wilder\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg","@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#mainImage","width":840,"height":368,"caption":"Mysql .IBD"},"primaryImageOfPage":{"@id":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/#mainImage"},"datePublished":"2022-01-20T07:51:36-05:00","dateModified":"2022-01-20T07:54:02-05:00"},{"@type":"WebSite","@id":"https:\/\/blog.index.pe\/en\/#website","url":"https:\/\/blog.index.pe\/en\/","name":"Blog de Index.pe","description":"El Blog de Index.pe ofrece art\u00edculos detallados sobre creaci\u00f3n y gesti\u00f3n de p\u00e1ginas web, dominios, hosting, marketing online, WordPress, SEO, SSL y Actualidad","inLanguage":"en-US","publisher":{"@id":"https:\/\/blog.index.pe\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"Blog de index.pe - Actualidad, Tecnologia, Redes, Internet, Webmaster","og:type":"article","og:title":"Abrir archivo .IBD con MySQL Blog de Index.pe","og:description":"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \/data\/nombre_basedatos\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:","og:url":"https:\/\/blog.index.pe\/en\/abrir-archivo-ibd-con-mysql\/","og:image":"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg","og:image:secure_url":"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg","og:image:width":840,"og:image:height":368,"article:published_time":"2022-01-20T12:51:36+00:00","article:modified_time":"2022-01-20T12:54:02+00:00","article:publisher":"https:\/\/www.facebook.com\/index.pe","twitter:card":"summary","twitter:title":"Abrir archivo .IBD con MySQL Blog de Index.pe","twitter:description":"Importar archivos .IBD a MySQLAbrir archivos .IBD desde phpMyAdmin\u00bfComo abrir archivos .IBD? SOLUCION: Necesitaras conocer la estructura exacta de la tabla (sentencia CREATE TABLE). Crea la tabla con la misma estructura.Ejecutar consulta SQL: ALTER TABLE nombre_tabla DISCARD TABLESPACE;Copiar el archivo ibd nombre_table.ibd dentro de su directorio \/data\/nombre_basedatos\/Ejecutar consulta SQL: ALTER TABLE nombre_tabla IMPORT TABLESPACE; NOTA: Recomendamos realizar:","twitter:image":"https:\/\/blog.index.pe\/wp-content\/uploads\/2022\/01\/maria-mysql.jpg"},"aioseo_meta_data":{"post_id":"1315","title":null,"description":null,"keywords":[],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":{"id":"aioseo-article-638f98bd76b8e","slug":"article","graphName":"Article","label":"Art\u00edculo","properties":{"type":"BlogPosting","name":"#post_title","headline":"#post_title","description":"#post_excerpt","image":"","keywords":"","author":{"name":"#author_name","url":"#author_url"},"dates":{"include":true,"datePublished":"","dateModified":""}}},"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2022-01-20 12:28:36","updated":"2025-07-22 06:13:22","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"seo_analyzer_scan_date":null},"a3_pvc":{"activated":true,"total_views":2664,"today_views":0},"_links":{"self":[{"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/posts\/1315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/comments?post=1315"}],"version-history":[{"count":2,"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/posts\/1315\/revisions"}],"predecessor-version":[{"id":1318,"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/posts\/1315\/revisions\/1318"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/media\/1316"}],"wp:attachment":[{"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/media?parent=1315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/categories?post=1315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.index.pe\/en\/wp-json\/wp\/v2\/tags?post=1315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}