We are running Percona MySQL 8.0.22-13 on our primary database server and want to use Percona Xtrabackup 80-8.0.23-16 to backup only our primary database. [MyCommanyDB]
We have a development server that we refresh frequently running our dev database [MyCompanyDB_dev]. Is it possible to use Percona Xtrabackup to backup only our primary database from our primary database [MyCompanyDB] and restore that database on our development server dev database? [MyCompanyDB_dev] If not, this should definitely be a feature request to add to Xtrabackup.
Doing mydumper/mysqldump + importing into the new DB does work but it’s VERY slow.
If the feature isn’t included in Xtrabackup , Are their any good workarounds for to implement this? [and some shell commands to implement this?]