The backup and restore of a complete database is an extensive exercise. But what if you need to restore just one table which has been mistakenly modified by an incorrect query? Help is at hand with Percona XtraBackup.
Restore Single Table
Here we will take the backup of the sbtest2 table and restore it. The initial checksum of the table is given below:
8.0.19>CHECKSUM TABLE sbtest2; +--------------+-----------+ | Table | Checksum | …[Read more]