# MySQL dump

**URL:** <https://forums.percona.com/t/mysql-dump/7858>\
**Category:** Percona XtraBackup\
**Created:** [August 6, 2020, 7:43am UTC](https://forums.percona.com/t/mysql-dump/7858 "2020-08-06T07:43:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 6, 2020, 7:43am UTC](https://forums.percona.com/t/mysql-dump/7858/1 "2020-08-06T07:43:18Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 6, 2020, 8:10am UTC](https://forums.percona.com/t/mysql-dump/7858/2 "2020-08-06T08:10:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 6, 2020, 8:13am UTC](https://forums.percona.com/t/mysql-dump/7858/3 "2020-08-06T08:13:39Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 6, 2020, 8:15am UTC](https://forums.percona.com/t/mysql-dump/7858/4 "2020-08-06T08:15:10Z")

</div>

any reserved keyboard list between 5.7 and 8.0.19 ?