Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Recover deleted forum
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sabre0
Starting Member

22 Posts

Posted - 07 March 2009 :  08:45:45  Show Profile
Hi,
One of my users has accidently deleted a forum whilst "cleaning up". I have tried copying posts from a backup database, but must have missed something in a related table link because the server locks up with an asp error 0115.

Is there a correct procedure for restoring forums or is there a procedure for importing selected records from the backup database.

The back up database is 3 weeks old so in essence I am looking to merge rather than restore.

Thanks in advance for any help.

Colin

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 07 March 2009 :  09:22:23  Show Profile  Visit HuwR's Homepage
no, other than restoring the whole databse it is not really possible to retrieve a particular forum.

you could try restoring your backup to another database and then exxtracting the relevant data but it will not be easy, you will need quite a high level of sql knowledge to do it.
Go to Top of Page

sabre0
Starting Member

22 Posts

Posted - 07 March 2009 :  10:13:46  Show Profile
Thanks for your quick reply.
re extracting relevant data, I previously tried copying from forum_forum and forum_topics but clearly missed something. How can I isolate all of the relevant data.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 March 2009 :  10:16:05  Show Profile  Send ruirib a Yahoo! Message
As Huw wrote you need to have a good knowledge of SQL for that. You'd need to retrive records based on the value of FORUM_ID


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

sabre0
Starting Member

22 Posts

Posted - 07 March 2009 :  10:56:38  Show Profile
Thanks
no problem with SQL, I just want to be sure to get everything in one pass from the linked tables.
There is more than forum_category, forum_forum, forum_topics, forum_replies etc
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 March 2009 :  11:56:42  Show Profile  Send ruirib a Yahoo! Message
That is the most relevant stuff. Other than that, maybe just subscriptions.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

sabre0
Starting Member

22 Posts

Posted - 08 March 2009 :  07:45:14  Show Profile
Thanks for the help,
I am nearly there.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.41 seconds. Powered By: Snitz Forums 2000 Version 3.4.07