Restoring database: connection lost or killed wtf?

[dutchbb]

Every time I try to restore the database either the connection is lost or killed after a while.

Every time it's the table postindex, it takes hours to restore this table and after 2 hours or so I get this problem.
I started 3 times and every time it's the same prob. Also is it normal everything must be overwritten again with every new session or can I resume where it stopped?


Thank you

[Zachery]

You could not restore the table, but they you would need to rebuild it.

Your server might not be tuned properly to do a restore.

[dutchbb]

i don't understand the first sentence but I'm going to let my host deal with it, I'm trying to move servers for 5 days now and everything went wrong what could go wrong...
tnx

[Zachery]

In the SQL file, you could remove the bit about restoring the table.

Instead you would recreate it and rebuild the search index after it vB is up and running.

[Icheb]

Another solution would be to do a backup on every table instead of on the entire database. That way, you don't have to open the entire backup file and remove the postindex bit, which can take a long time depending on the size of the file. Then you just import the files on the new server and recreate the postindex table.

[dutchbb]

Ok thankyou but wy can't the server just stay connected, isn't normal imo. To bad my webhost support is terrible