database restore failed-2mb sql file

[fonoop]

Hello everyone, I just signed up for a powweb account yesterday and so far its been great. I love the "ops" center and all the features in there as well.

Anyway, I'm now moving my postnuke based website from my old host and I have been able to upload all of my tables except a single 2.04Mb table that includes all the posts on the message board. All I get after it uploads is "No Sql Query!" at the top of the page and the table fails to appear among the others. It did not do this for the tables that were sucessful so I guess that's an error message. It was a 10Mb database broken up into 1mb chunks, so I had about a dozen files to restore into the database. All of the "chunks" worked except that one.

Is there a limit on the size of file you can upload through php?

I tried HalfaBee's backup/restore script as well and it gave me a little more descriptive error of "error uploading file" or something similar.

Thanks,
Brian

[HalfaBee]

Big restores sometimes cause problems in phpmyadmin, you might have been just over the upload limit

ftp the file to the server first.

[fonoop]

It looks like 1Mb was the limit, but no fear I found a way around. :)
I just broke that .sql file into bits by copying sections at a time and pasting them into the sql query box. Works like a charm now, thanks!