I read this: https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html it seems we can’t restore mysql sys DB from percona xtradB cluster 5.7 to 8.0.19, right ? how about “mysql” Db, it seems installed by a fresh installation?

If you include the mysql database as part of your regular backup, then no, you do not need to use pt-show-grants. All username/passwords/grant information is stored in mysql database. You should back this database up as part of your regular backup policy.

what is mysql database and sys database is about

MySQL & MariaDB Percona XtraDB Cluster 8.x

matthewb August 28, 2020, 8:54am 7

Please do not link to other posts asking for more free assistance.

Topic		Replies	Views
Migrate to Percona xtraDB cluster 8.0.19 Percona XtraDB Cluster 5.x mysql	3	728	July 7, 2021
How to expert MySQL user account, with password and right permission to another MySQL server Database Monitoring and Management community , mysql , percona	12	5588	August 27, 2020
how to migrate MySQL user + password + permission from old MySQL to a newer mysQL Percona XtraDB Cluster 8.x community , mysql , percona	1	4180	August 11, 2020
use xtrabackup to backup data from Percona xtraDB cluster 5.7.23 to 8.0.19 Percona XtraDB Cluster 8.x community , pmm , mysql , percona	5	1496	September 18, 2020
MySQL dump Percona XtraBackup	3	638	August 6, 2020

what is mysql database and sys database is about

Related topics