Restoring large mysql database

[lingo12473]

Hi. What is the best way to restore a large database file. I am trying to move my local testserver's database onto my hosting database but everytime I try to import with bigdump or mysqldumper the process always stops midway and I get an error for both scripts. Bigdump returns "Page unavailable, or wrong url!". Even when I upload small chunks at a time I usually end up running into a problem. It seems to be random. Is there any way to solve this problem? I have also tried phpmyadmin but it times out before it finishes and asks me to upload the file again (I split up my files into 20mb chunks just for phpmyadmin).

Thanks

Note I have mysql saved as .gz since my hosting doesnt have enough space to store my raw sql file.

 

[webbrewe]

I've found sometimes zipped files just don't work and you have to use a raw sql file. The location can be a factor too - flash drives generally don't work, but that maybe a transfer speed issue.

 

[lingo12473]

hm. ok i will try to use a full sql file next. need to wait for them to uncap my storage space so i can upload my sql file (1gb in .sql form)