MySQL dump

MySQL & MariaDB Percona XtraBackup
1

hi,

how to do MySQL dump, a set of MySQL statement to recreate all necessary DB from Percona xtraDB cluster 5.7 to percona xtradB cluster 8.0.19 using xtrabackup?

and how to import them using xtrabackup ?

2

XtraBackup and mysqldump are different tools from different purposes.
XtraBackup copies files on the physical level and mysqldump creates logical statements.
You actually can use either of them to copy data from 5.7 and load it into 8.0

3

hi,

tks.

“You actually can use either of them to copy data from 5.7 and load it into 8.0”
any menu or URL told me how to completely copy all schema + data+ mysql logic to percona xtraDB cluster 5.7 to 8.0.19 ?

4

any reserved keyboard list between 5.7 and 8.0.19 ?