Web Hosting Talk







View Full Version : abnormal mysql restore process


VapoRub
08-23-2004, 01:24 AM
hi,

i'm trying to restore a monthly backup for a user and it seems to hang when it is

restoring the db. (the db is about 40-50 mb)

I'm restoring via ./restorepkg user

Is it normal to take that long?

Serverload also went from 0.8 to 3.0-4.0 average.

Steven
08-23-2004, 01:32 AM
It is common to see that kind of load when doing a restore. It all depends on how your /etc/my.cnf is configured.

KamiDev
08-23-2004, 03:19 AM
A 40-50mb database can and will take a very long amount of time to restore. I can't give you an exact figure, but I'm sure it's at least over half an hour. Maybe a few hours? I don't know, I've never restored a database that large.