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:
- what is the best option to migrate the 200G database from the old vm to the new vm?
- Is there any option to increase the mysqldump restore? NOTE: the vm have many resources that not usable while restore process running.