Very slow database restore using mysqldumper

[Lock Down]

It is your host. I have the same size database on 2 seperate servers and use mysqldumper to restore both. One takes 3 minutes and the other has to continually timeout and restart so it takes forever.

If the host wasn't cheap I would move. Even using mysql ommands to import and export take forever from the ssh command line and often timeout.

Lock Down Reviewed by Lock Down on 15th Jul 2011. Very slow database restore using mysqldumper As you can see in the picture below, my 6 mb compressed database took 185 minutes and still going on to restore. Is it normal? http://i.imgur.com/zbORT.png Rating: 5

[damnyou]

It is your host. I have the same size database on 2 seperate servers and use mysqldumper to restore both. One takes 3 minutes and the other has to continually timeout and restart so it takes forever.

If the host wasn't cheap I would move. Even using mysql ommands to import and export take forever from the ssh command line and often timeout.

I am on the unmanaged VPS server. I tested my hard disk speed and I am getting more than 100MB per sec. It may be possible due to the fact that I am using inferior suphp as my php handler. I have no problem using mod_php but when ever i switched to it than during each wordpress plugin install/upgrade, it asks me for the server's FTP details. Why it asks me server's ftp details in mod_php but not in suphp?
And according to you which is better? Mod_PHP or suPHP?