{"id":2674,"date":"2022-12-14T17:39:51","date_gmt":"2022-12-14T17:39:51","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=2674"},"modified":"2023-07-22T17:39:57","modified_gmt":"2023-07-22T17:39:57","slug":"restore-single-mysql-table-from-xtrabackup","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup","title":{"rendered":"Restore single MySQL table (ibd) from Xtrabackup (video demo)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a feedback on my previous blog about <a href=\"http:\/\/kedar.nitty-witty.com\/mysql-interview-chatgpt-is-not-your-dba\" target=\"_blank\" rel=\"noopener\" title=\"\">MySQL Interview with ChatGPT<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is a video recording of the steps described below for restoring single table from xtrabackup.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Restore single MySQL table from Xtrabackup\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/nDMxPn49xLg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\">Restore single MySQL Table From Xtrabackup<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create a compressed MySQL backup using Xtrabackup<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">xtrabackup --backup --compress --compress-threads=8 --target-dir=\/root\/backupdir<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Output in backup directory<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@ip-172-31-83-17 ~]# ls -lhtr \/root\/backupdir<br>total 3.1M<br>-rw-r-----. 1 root root 164K Dec 14 17:11 ibdata1.qp<br>drwxr-x---. 2 root root 31 Dec 14 17:11 sys<br>drwxr-x---. 2 root root 23 Dec 14 17:11 test<br>-rw-r-----. 1 root root 2.3M Dec 14 17:11 mysql.ibd.qp<br>-rw-r-----. 1 root root 287K Dec 14 17:11 undo_002.qp<br>-rw-r-----. 1 root root 287K Dec 14 17:11 undo_001.qp<br>drwxr-x---. 2 root root 161 Dec 14 17:11 mysql<br>drwxr-x---. 2 root root 8.0K Dec 14 17:11 performance_schema<br>-rw-r-----. 1 root root 188 Dec 14 17:11 binlog.000010.qp<br>-rw-r-----. 1 root root 106 Dec 14 17:11 binlog.index.qp<br>-rw-r-----. 1 root root 105 Dec 14 17:11 xtrabackup_binlog_info.qp<br>-rw-r-----. 1 root root 383 Dec 14 17:11 xtrabackup_logfile.qp<br>-rw-r-----. 1 root root 137 Dec 14 17:11 xtrabackup_checkpoints<br>-rw-r-----. 1 root root 1.4K Dec 14 17:11 ib_buffer_pool.qp<br>-rw-r-----. 1 root root 445 Dec 14 17:11 backup-my.cnf.qp<br>-rw-r-----. 1 root root 458 Dec 14 17:11 xtrabackup_info.qp<br>-rw-r-----. 1 root root 130 Dec 14 17:11 xtrabackup_tablespaces.qp<br><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Dropping a table (to create dummy emergency)<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@ip-172-31-83-17 ~]# mysql<br>...<br>mysql&gt; drop table test.t1;<br>Query OK, 0 rows affected (0.02 sec)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Copy backup files to a temporary location to extract single table for restoring<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@ip-172-31-83-17 ~]# mkdir \/tmp\/restore<br>[root@ip-172-31-83-17 ~]# cp -R \/root\/backupdir\/* \/tmp\/restore<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Decompress the backup files<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@ip-172-31-83-17 ~]# xtrabackup --decompress --target-dir=\/tmp\/restore --remove-original\n2022-12-14T17:12:18.239004-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=\/var\/lib\/mysql --log_bin=\/var\/lib\/mysql\/binlog\n2022-12-14T17:12:18.239194-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --user=root --password=* --decompress=1 --target-dir=\/tmp\/restore --remove-original=1\nxtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)\n2022-12-14T17:12:18.259287-00:00 0 [Note] [MY-011825] [Xtrabackup] decompressing .\/backup-my.cnf.qp\n...<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br><strong>Prepare the backup for importing with &#8211;export option<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@ip-172-31-83-17 ~]# xtrabackup --prepare --export --target-dir=\/tmp\/restore\n...\n2022-12-14T17:12:27.172446-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=.\/ --innodb_undo_tablespaces=2 --server-id=0 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0\n2022-12-14T17:12:27.172601-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --export=1 --target-dir=\/tmp\/restore\nxtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)\n2022-12-14T17:12:27.172633-00:00 0 [Note] [MY-011825] [Xtrabackup] auto-enabling --innodb-file-per-table due to the --export option\n2022-12-14T17:12:27.172650-00:00 0 [Note] [MY-011825] [Xtrabackup] cd to \/tmp\/restore\/\n2022-12-14T17:12:27.172750-00:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be not prepared yet.\n2022-12-14T17:12:27.173185-00:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1\n2022-12-14T17:12:27.181337-00:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile detected: size=8388608, start_lsn=(19690717)\n2022-12-14T17:12:27.185980-00:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:\n2022-12-14T17:12:27.186001-00:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .\n2022-12-14T17:12:27.186011-00:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend\n...\n2022-12-14T17:12:29.477906-00:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...\n2022-12-14T17:12:29.580573-00:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...\n2022-12-14T17:12:29.598559-00:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 19691030\n2022-12-14T17:12:29.599239-00:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1\n2022-12-14T17:12:29.600397-00:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Reviewing exported tablespace files<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@ip-172-31-83-17 ~]# cd \/tmp\/restore\/test\/<br>[root@ip-172-31-83-17 test]# ls -lhtr<br>total 116K<br>-rw-r--r--. 1 root root 112K Dec 14 17:12 t1.ibd<br>-rw-r--r--. 1 root root 706 Dec 14 17:12 t1.cfg<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Creating table, discarding empty tablespace and getting ready for restore<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; use test<br>Database changed<br>mysql&gt; create table t1 (<code>id<\/code> int unsigned NOT NULL AUTO_INCREMENT,<br>-&gt; <code>val<\/code> varchar(10) DEFAULT NULL,<br>-&gt; PRIMARY KEY (<code>id<\/code>)<br>-&gt; ) ENGINE=InnoDB;<br>Query OK, 0 rows affected (0.02 sec)<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; select * from test.t1;\nEmpty set (0.00 sec)\nmysql&gt; alter table t1 discard tablespace;\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Restoring tablespace files and importing tablespace<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; ! cp \/tmp\/restore\/test\/* \/var\/lib\/mysql\/test\/\nmysql&gt; ! ls -lhtr \/var\/lib\/mysql\/test\/\ntotal 116K\n-rw-r--r--. 1 root root 112K Dec 14 17:13 t1.ibd\n-rw-r--r--. 1 root root 706 Dec 14 17:13 t1.cfg\n\nmysql&gt; alter table t1 import tablespace;\nERROR 1815 (HY000): Internal error: Cannot reset LSNs in table <code>test<\/code>.<code>t1<\/code> : Tablespace not found\n\nmysql&gt; ! chown mysql:mysql \/var\/lib\/mysql\/test -R\nmysql&gt; alter table t1 import tablespace;\nQuery OK, 0 rows affected (0.04 sec)<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; select * from test.t1;<br>+----+------+<br>| id | val |<br>+----+------+<br>| 1 | a |<br>| 2 | b |<br>| 3 | c |<br>+----+------+<br>3 rows in set (0.00 sec)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Alright, that&#8217;s it. We have successfully restored our table that was &#8220;accidentally&#8221;  dropped from the full Xtrabackup.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Quick recipes  for Xtrabackup <\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Installing Percona Xtrabackup<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo yum install https:\/\/repo.percona.com\/yum\/percona-release-latest.noarch.rpm<br>yum install qpress<br>yum install percona-xtrabackup-80<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Creating Backup<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">xtrabackup --backup --compress --compress-threads=8 --stream=xbstream --parallel=4 --target-dir=\/root\/backupdir &gt; \/root\/backupdir\/backup.xbstream<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Restoring full backup<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">xbstream -x -p 4 -C \/var\/lib\/mysql\/ &lt; \/root\/backupdir\/backup.xbstream<br>xtrabackup --decompress --remove-original --parallel=8 --target-dir=\/var\/lib\/mysql\/<br>xtrabackup --prepare --target-dir=\/var\/lib\/mysql\/<br>chown mysql:mysql -R \/var\/lib\/mysql<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I hope this helps.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Update:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Extract Table Definition from IBD (datafile)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">What if you have the ibd file but don&#8217;t have the table definition? In such scenarios you can use the ibd2sdi, the innodb tablespace extraction utility. It will extract the Serialized dictionary information (SDI) from InnoDB tablespace files. <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/ibd2sdi.html\" target=\"_blank\" rel=\"noopener nofollow\" title=\"\">Refer this<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;d also like to highlight the tool created by Marcelo here: <a href=\"https:\/\/github.com\/altmannmarcelo\/sdi2ddl\" target=\"_blank\" rel=\"noopener nofollow\" title=\"\">https:\/\/github.com\/altmannmarcelo\/sdi2ddl<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a&hellip;\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377],"tags":[627,427,366,625,530,516,626,628,369],"class_list":["post-2674","post","type-post","status-publish","format-standard","category-mysql","category-mysql-articles","tag-idb2sdi","tag-mysql","tag-restore","tag-restore-definition-from-ibd","tag-restore-ibd","tag-restore-single-table","tag-restore-without-table-definition","tag-sdi2ddl","tag-xtrabackup"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Kedar\"\/>\n\t<meta name=\"google-site-verification\" content=\"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA\" \/>\n\t<meta name=\"msvalidate.01\" content=\"116B62074CBCA1BA99B8CCE09CCF2FB8\" \/>\n\t<meta name=\"keywords\" content=\"idb2sdi,mysql,restore,restore definition from ibd,restore ibd,restore single table,restore without table definition,sdi2ddl,xtrabackup\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Change Is Inevitable | Kedar Vaijanapurkar&#039;s Blog for MySQL, technology and various subjects\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable\" \/>\n\t\t<meta property=\"og:description\" content=\"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2022-12-14T17:39:51+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-07-22T17:39:57+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable\" \/>\n\t\t<meta name=\"twitter:description\" content=\"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#article\",\"name\":\"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable\",\"headline\":\"Restore single MySQL table (ibd) from Xtrabackup (video demo)\",\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"},\"datePublished\":\"2022-12-14T17:39:51+00:00\",\"dateModified\":\"2023-07-22T17:39:57+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#webpage\"},\"articleSection\":\"MySQL, MySQL-Articles, idb2sdi, MySQL, restore, restore definition from ibd, restore ibd, Restore single table, restore without table definition, sdi2ddl, xtrabackup\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"name\":\"MySQL-Articles\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"position\":3,\"name\":\"MySQL-Articles\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#listItem\",\"name\":\"Restore single MySQL table (ibd) from Xtrabackup (video demo)\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#listItem\",\"position\":4,\"name\":\"Restore single MySQL table (ibd) from Xtrabackup (video demo)\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"name\":\"MySQL-Articles\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#webpage\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup\",\"name\":\"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable\",\"description\":\"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/restore-single-mysql-table-from-xtrabackup#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"datePublished\":\"2022-12-14T17:39:51+00:00\",\"dateModified\":\"2023-07-22T17:39:57+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/\",\"name\":\"..::CHANGE is INEVITABLE::..\",\"description\":\"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable","description":"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore","canonical_url":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup","robots":"max-image-preview:large","keywords":"idb2sdi,mysql,restore,restore definition from ibd,restore ibd,restore single table,restore without table definition,sdi2ddl,xtrabackup","webmasterTools":{"google-site-verification":"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA","msvalidate.01":"116B62074CBCA1BA99B8CCE09CCF2FB8","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#article","name":"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable","headline":"Restore single MySQL table (ibd) from Xtrabackup (video demo)","author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"},"datePublished":"2022-12-14T17:39:51+00:00","dateModified":"2023-07-22T17:39:57+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#webpage"},"isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#webpage"},"articleSection":"MySQL, MySQL-Articles, idb2sdi, MySQL, restore, restore definition from ibd, restore ibd, Restore single table, restore without table definition, sdi2ddl, xtrabackup"},{"@type":"BreadcrumbList","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/kedar.nitty-witty.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","position":2,"name":"MySQL","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","name":"MySQL-Articles"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","position":3,"name":"MySQL-Articles","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#listItem","name":"Restore single MySQL table (ibd) from Xtrabackup (video demo)"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#listItem","position":4,"name":"Restore single MySQL table (ibd) from Xtrabackup (video demo)","previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","name":"MySQL-Articles"}}]},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author","url":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"WebPage","@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#webpage","url":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup","name":"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable","description":"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup#breadcrumblist"},"author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"creator":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"datePublished":"2022-12-14T17:39:51+00:00","dateModified":"2023-07-22T17:39:57+00:00"},{"@type":"WebSite","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website","url":"https:\/\/kedar.nitty-witty.com\/blog\/","name":"..::CHANGE is INEVITABLE::..","description":"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","inLanguage":"en-US","publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"}}]},"og:locale":"en_US","og:site_name":"Change Is Inevitable | Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","og:type":"article","og:title":"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable","og:description":"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore","og:url":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup","article:published_time":"2022-12-14T17:39:51+00:00","article:modified_time":"2023-07-22T17:39:57+00:00","twitter:card":"summary","twitter:title":"Restore single MySQL table (ibd) from Xtrabackup (video demo) | Change Is Inevitable","twitter:description":"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore"},"aioseo_meta_data":{"post_id":"2674","title":null,"description":"In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore","keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"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":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"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":0,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2022-12-14 17:15:21","updated":"2025-08-16 19:18:27","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\" title=\"MySQL\">MySQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles\" title=\"MySQL-Articles\">MySQL-Articles<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tRestore single MySQL table (ibd) from Xtrabackup (video demo)\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/kedar.nitty-witty.com\/blog"},{"label":"MySQL","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql"},{"label":"MySQL-Articles","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles"},{"label":"Restore single MySQL table (ibd) from Xtrabackup (video demo)","link":"https:\/\/kedar.nitty-witty.com\/blog\/restore-single-mysql-table-from-xtrabackup"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=2674"}],"version-history":[{"count":8,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2674\/revisions"}],"predecessor-version":[{"id":2951,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2674\/revisions\/2951"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=2674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=2674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=2674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}