Fastest way of restoring MYSQL Dump

Asked Sep 03 '13 at 04:36

Active Jan 31 '15 at 22:14

Viewed 1,741 times

I have a dump of 2gb size and its taking more than 2 days to restore whole database and still going on.

I am using this command to restore my Database from dump file

mysql -uroot -ppassword new_db < old_db.sql

is there any faster way to do the same. so I can wrap up the Restoration task in one day or less.

asked Sep 03 '13 at 04:36

Amitkumar Jha

There must be some problem, 2gb is not big enough to take 2 days – Hanky Panky Sep 03 '13 at 04:39
yes console comman is the optimal way! – Tahir Yasin Sep 03 '13 at 04:39
2

A 2gb restore should take less than 5 minutes on a small server. You have other issues. – Rob Sep 03 '13 at 04:39
Thanks @hanky,@tahir,@rob my db has a lot of database constraints might this cause a huge delay and also I am using innodb as mysql engine. can you help me in what I am doing wrong. – Amitkumar Jha Sep 03 '13 at 04:44
http://stackoverflow.com/questions/1112069/is-there-a-faster-way-to-load-mysqldumps Read jeffhiltz post. – d.danailov Sep 03 '13 at 04:45
Did you look at the errors log? – Hanky Panky Sep 03 '13 at 04:53

0 Answers0