Hello. I need to move database from one server (Mysql 5.1.73) to another Percona 5.6.25-73.1.
I made a dump
mysqldump --opt db > db.sql
and trying to load it to mysql
mysql db < db.sql
db.sql - 9GB
DB engine - Innodb.
CentOS 7.1 64 Software raid 1 2xSata disk tps 150-250
I have already loading for 6 hours and it seems load only about half of data. Can i somehow speed up this process ?