For me it was for a long time not clear if a mariadb-backup full backup can be used to do partial table or schema restores. Now we faced this challenge with a customer. So time to try it out…
This test was made with MariaDB 10.5.5. So it may not work with some older MariaDB releases…
Backup
Because I do not know during the backup if I need a full or a partial restore I always want to do a full mariadb-backup backup!
The full backup can be done as normal but the prepare should not be done yet …
