FUDforum: FUDforum 3.0+ » Recovering Database After Botched Upgrade

Home » FUDforum Development » FUDforum 3.0+ » Recovering Database After Botched Upgrade

Show: Today's Messages :: Polls :: Message Navigator

Re: Recovering Database After Botched Upgrade [message #164394 is a reply to message #164393]

Thu, 03 February 2011 19:49

The Witcher

Messages: 675
Registered: May 2009
Location: USA

Karma:

Senior Member

Sounds about right!

1. I don't quite understand 'nntp syncing" I'm not quite that knowledgeable about the higher end functions. But yes you would want new users and posts suspended for maintenance.

2. Yes you would want a current dump of your present forum!!!

3. Yes export users table (whatever you have it labeled as), I believe you would export it as a replace file, but I would make copies of replace and insert,... Check table block> Export> ensure only users selected> select export type (insert, update, or replace)> name file to be saved > check save as file block> GO.

4. TV_1 etc are temporary files as I understand it, and are replaced or used during the consistency checks.

5. yes.

6. Just click import and browse to the saved file.

That should do it, if nothing else it just supports the reasoning for making a dump before upgrading.

Good luck

"I'm a Witcher, I solve human problems; not always using a sword!"

Report message to a moderator

[Message index]

		Recovering Database After Botched Upgrade By: jm2morri on Wed, 02 February 2011 18:14
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 01:36
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 10:38
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 11:20
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 15:22
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 16:42
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 18:48
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 19:49
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 20:24
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 20:59

Previous Topic:	Condensed Categories displaying "opened" when clicked
Next Topic:	Lost Forum Group "+" and "-" Image to Expand and Collapse Forum Category

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 04:53:19 GMT 2024

Total time taken to generate the page: 0.04946 seconds