Not the answer you need?
Register and ask your own question!

MySQL dump

DBA100DBA100 Current User Role Patron
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 ?

Answers

  • vadimtkvadimtk Contributor Percona Staff Role
    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
  • DBA100DBA100 Current User Role Patron
    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 ?
  • DBA100DBA100 Current User Role Patron
    any reserved keyboard list between 5.7 and 8.0.19 ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.