# What is the best way to migrate 200G database

**URL:** <https://forums.percona.com/t/what-is-the-best-way-to-migrate-200g-database/23420>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [July 6, 2023, 3:39pm UTC](https://forums.percona.com/t/what-is-the-best-way-to-migrate-200g-database/23420 "2023-07-06T15:39:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![elkhedewy](https://avatars.discourse-cdn.com/v4/letter/e/5fc32e/32.png) [@elkhedewy](https://forums.percona.com/u/elkhedewy)\
**Post date:** [July 6, 2023, 3:39pm UTC](https://forums.percona.com/t/what-is-the-best-way-to-migrate-200g-database/23420/1 "2023-07-06T15:39:03Z")

</div>

Hello,

I’ve mysql 5.6 running on production server. And now i’ve a new VM with mysql version 8.0, I need to migrate 200G database from the old vm to the new vm with version 8.0…I’ve tried mysqldump and mysql restore but it takes about 24 hours to restore the 200G database.

So the question is:

1. what is the best option to migrate the 200G database from the old vm to the new vm?
2. Is there any option to increase the mysqldump restore? NOTE: the vm have many resources that not usable while restore process running.

---

<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:** [July 6, 2023, 3:52pm UTC](https://forums.percona.com/t/what-is-the-best-way-to-migrate-200g-database/23420/2 "2023-07-06T15:52:22Z")

</div>

Hello @elkhedewy,  
You need to look at [GitHub - mydumper/mydumper: Official MyDumper Project](https://github.com/mydumper/mydumper)  
mysqldump is single-threaded, which is why you are not seeing many resources used. mydumper is multi-threaded for both dump and restore (myloader). You will see much faster export times using mydumper.

---

<div class="post-metadata">

**Author:** ![elkhedewy](https://avatars.discourse-cdn.com/v4/letter/e/5fc32e/32.png) [@elkhedewy](https://forums.percona.com/u/elkhedewy)\
**Post date:** [January 9, 2024, 4:25pm UTC](https://forums.percona.com/t/what-is-the-best-way-to-migrate-200g-database/23420/3 "2024-01-09T16:25:03Z")

</div>

Hello,

Is that possible to restore sql file created using mysqldump and then use myloader to restore the sql file?  
If yes, How to do that?

Regards,

---

<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:** [January 9, 2024, 4:37pm UTC](https://forums.percona.com/t/what-is-the-best-way-to-migrate-200g-database/23420/4 "2024-01-09T16:37:35Z")

</div>

@elkhedewy No, the result from mysqldump is not compatible with myloader. mysqldump outputs everything to a single file, where mydumper outputs to separate files which myloader expects.