I see what you need.
You need this :
http://www.scibit.com/Products/Softw...ils/Mascon.htm
... try out the Freeware version... see if you like it... if you do, you'll have to pay for the full version to be able to put your backup databases back.
At only $49, it's a bloody bargain!!!
With that, you wouldn't even need a backup. You could just make a copy from one server, and dump it directly to the other. Sweet as a nut!!
I was pointed to that utility because our forums database got too large for the vB Admin CP to handle, and we don't have Telnet access to our webserver.
With this application, I can manipulate our database fully.... I can even get rid of the potential security problem of using phpMyAdmin from the web server. :devious:
One thing though.... you will need to go through the vB database structure, and change any fields that are set to NOT NULL, to NULL... as some fields in some records will be blank, even though they shouldn't have NULL values.
When importing a database, you'll notice that it will halt part the way through, due to that error cropping up.
You can always go back and set the NULL fields back to NOT NULL when you've properly imported.
That shoud only affect fields that accept alphanumeric data though. Not INTEGER, and such.
Another thing.... DO NOT EVER set the program to CONTINUE ON ERRORS... because it will continue, but you won't have a complete database.
Anyway... that's what you are looking for. I am 100% you will be happy with it. I am.