# Newbie question import mysql dump to percona

**URL:** <https://forums.percona.com/t/newbie-question-import-mysql-dump-to-percona/12864>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [November 4, 2021, 12:25pm UTC](https://forums.percona.com/t/newbie-question-import-mysql-dump-to-percona/12864 "2021-11-04T12:25:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zakonuzemunu](https://avatars.discourse-cdn.com/v4/letter/z/8e7dd6/32.png) [@zakonuzemunu](https://forums.percona.com/u/zakonuzemunu)\
**Post date:** [November 4, 2021, 12:25pm UTC](https://forums.percona.com/t/newbie-question-import-mysql-dump-to-percona/12864/1 "2021-11-04T12:25:35Z")

</div>

Hello, I’m new to percona, and trying to make transition from mysql 5.7 to Percona-XtraDB-cluster-57.

Mysql dump command:  
mysqldump -h localhost --opt --all-databases --add-drop-table --events -u \> dump.sql

On percona server I tried to do:mysql -u root -p --binary-mode -o \< dump.sql

But after some time when I check databases on percona nothing happends.

Please, can you write me how to do this?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [November 4, 2021, 1:13pm UTC](https://forums.percona.com/t/newbie-question-import-mysql-dump-to-percona/12864/2 "2021-11-04T13:13:33Z")

</div>

Hello @zakonuzemunu,  
Two things: 1) PXC is a drop-in replacement. You can stop your current MySQL 5.7, remove the binary/packages, install PXC and start it up without having to dump/import.  
2) Your command to import the dump, remove `--binary-mode` and `-o` because you did not make a binary dump. You can also add `-v` for some increased verbosity. I would recommend checking out [mydumper](https://github.com/maxbube/mydumper) as a faster alternative to mysqldump, but in reality, option 1) above is the easiest for switching to PXC.