Author |
Topic |
|
sabre0
Starting Member
22 Posts |
Posted - 07 March 2009 : 08:45:45
|
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
|
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. |
|
|
sabre0
Starting Member
22 Posts |
Posted - 07 March 2009 : 10:13:46
|
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. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
sabre0
Starting Member
22 Posts |
Posted - 07 March 2009 : 10:56:38
|
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 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
sabre0
Starting Member
22 Posts |
Posted - 08 March 2009 : 07:45:14
|
Thanks for the help, I am nearly there.
|
|
|
|
Topic |
|