# load 9GB sql

**URL:** <https://forums.percona.com/t/load-9gb-sql/4361>\
**Category:** Other MySQL® Questions\
**Created:** [August 20, 2015, 6:26am UTC](https://forums.percona.com/t/load-9gb-sql/4361 "2015-08-20T06:26:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![silent-ion](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@silent-ion](https://forums.percona.com/u/silent-ion)\
**Post date:** [August 20, 2015, 6:26am UTC](https://forums.percona.com/t/load-9gb-sql/4361/1 "2015-08-20T06:26:52Z")

</div>

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  
copy 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 ?

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [August 21, 2015, 1:05pm UTC](https://forums.percona.com/t/load-9gb-sql/4361/2 "2015-08-21T13:05:29Z")

</div>

Hi silent-ion;

The likely limiting factor is your disk speed. But you probably can speed it up using a parallel dump / restore tool like MyDumper:

[url][https://launchpad.net/mydumper[/url]](https://launchpad.net/mydumper%5B/url%5D)

-Scott