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...
The post Restore single MySQL table from Xtrabackup (video demo) first appeared on ..::CHANGE …
[Read more]