Restore single table

Restore single MySQL table from Xtrabackup (video demo)

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 MySQL Interview with ChatGPT. Here is a video recording of the steps described below for restoring single table from xtrabackup. Create a compressed MySQL backup using Xtrabackup xtrabackup –backup –compress –compress-threads=8 –target-dir=/root/backupdir Output in backup directory [root@ip-172-31-83-17 ~]# ls -lhtr /root/backupdirtotal 3.1M-rw-r—–. 1 root root 164K Dec 14 17:11 ibdata1.qpdrwxr-x—. 2 root root 31 Dec 14 17:11 sysdrwxr-x—. 2 root root 23 Dec 14...