I’d like to use the partial backup feature to backup specific databases on a replica. If I have to recreate the replica, I can then restore those specific databases (which do not exist on the master, incidentally). When I read the documentation about restoring partial backups, it seems to indicate that we can only restore partial backups to a Percona XtraDB server. However, the examples used are for backing up just a single table. I want to backup a whole database and restore them.
Example: My server contains databases “shopping”, “shopping_archive”, “email”, “email_archive”. I want to backup just those databases whose names end in “_archive”. These do not exist on my master server. If I have to recreate the slave, I want to restore my latest “archive” backup to recover those extra databases.
Is this possible with just standard MySQL 5.6 Community Edition?