PDA

View Full Version : Timeout before limit it reached, and


Hotshot
10-27-07, 04:37 PM
My SQL databases are running awesomely compared to a few weeks ago, but I do have some issues, possibly due to my general lack of knowladge about database operations.

I run an Invision Power Board (licensed and everything), and I have a pretty large database as a result of having a large and active forum. If I exported it and then tried to import it at a later date, it wouldn't fit the 8.2mb limit, so I break it up into about 3 pieces when exporting/importing.

The problem (and it shouldn't be) is that one of them is 6mb, and I can never upload it all the way without getting timed out and having a partial upload. In fact it times out about 3mb into uploading it (about 15,000 posts out of 30+). Is there any way I can for-lack-of-a-better-term fix this? The limit is supposed to be 8 and not 3 so I shouldn't have to chop up a single table in order to get it all uploaded, but if there's no other way, can anyone recommend any way for me to be able to upload all of it, since I have no idea how to upload partial tables.

Thanks in advance,

Hotshot


edit: nevermind, I don't care. I found BigDump (http://www.ozerov.de/bigdump.php), and it is awesome!

YvetteKuhns
10-29-07, 09:32 AM
I requested in the wishlist a long time ago that PowWeb include BigDump in the Site Tools. Find other threads on this forum about it. It works better than phpmyadmin's import, because it can restart where it was interrupted! No time out problem!