# Issues with MYSQL to percona migration with innobackupex

**URL:** https://forums.percona.com/t/issues-with-mysql-to-percona-migration-with-innobackupex/4149
**Category:** Other MySQL® Questions
**Created:** [April 10, 2015, 3:01pm UTC](https://forums.percona.com/t/issues-with-mysql-to-percona-migration-with-innobackupex/4149 "2015-04-10T15:01:54Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![atfrys](https://avatars.discourse-cdn.com/v4/letter/a/d2c977/32.png) [@atfrys](https://forums.percona.com/u/atfrys)
#### Post date: [April 10, 2015, 3:01pm UTC](https://forums.percona.com/t/issues-with-mysql-to-percona-migration-with-innobackupex/4149/1 "2015-04-10T15:01:54Z")

</div>

I have been bangin my head against the wall on how to get from one MySQL server to my new percona cluster. I have done multiple methods, but the data gets corrupted.

I used percona xtrabackup to create a backup of our MySQL slave  
used the innobackupex --decompress  
Applied the logs  
copied the data and overwrote my existing percona (Yes I am in bootstrap mode with other nodes stopped  
percona starts, but most databases are corrupted. I tried this by pausing the slave and taking the backup as well as doing it live. The apply logs says everything is fine, but if I try to do any selects, no love for both system and user databases.

Any help would be appreciated.

Thank you

---

<div class="post-metadata">

### Author: ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)
#### Post date: [April 18, 2015, 5:08pm UTC](https://forums.percona.com/t/issues-with-mysql-to-percona-migration-with-innobackupex/4149/2 "2015-04-18T17:08:38Z")

</div>

Please send us the following:

- full command used to create the backup
- logs during the create and prepare phases (if you still have them)
- error log from the first node

After copying the files to the datadir did you change file ownership for the datadir to mysql? Can you start up node1 as regular mysql (not bootstrapped) and run a few select queries?
