| Author |
 Topic Search  Topic Options
|
Susan0722 
Senior Member
Joined: 31 July 2003
Status: Offline
Points: 238
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: How can I put back some topics?
Posted: 29 January 2006 at 12:05pm |
I was having some problems with posting in my forum. Thinking it might be the data base, I deleted (through admin) some users and topics.
Later I found the problem and it was not related to the database being "too full" now I would like to put those topics back in the forum.
I have a back up copy of the database with those topics in it, but I don't want to lose what has been posted since the deletion.
Is there anyway to move those "archived" topics back into the current active DB?
|
|
Pay for your copy of WebWIZ, it's worth it and you know it!
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 January 2006 at 1:00pm |
|
It could be possible but as the database is a relational database I wouldn't want to try it.
If you have the time and allot of patience, then give it ago, but make sure you have a backup of your present database in case you fail.
|
|
|
|
Susan0722
Senior Member
Joined: 31 July 2003
Status: Offline
Points: 238
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 January 2006 at 1:14pm |
What steps would I need to take to do this?
Is it just a matter of copying and pasting those into the current data base?
|
|
Pay for your copy of WebWIZ, it's worth it and you know it!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 January 2006 at 2:09pm |
|
It would be allot more difficult than that.
The depending on what database you are using (you didn't say), many of the index's use auto numbering, these need to match up with corresponding ,members, topics, posts, etc.
Trying to disable all the auto numbering, so posts, topics, etc. keep the same numbers may help, then re-enabling after.
But I think it will be quite complex and quite a hit and miss processes of trying different options.
|
|
|
|
Susan0722
Senior Member
Joined: 31 July 2003
Status: Offline
Points: 238
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 January 2006 at 2:33am |
I am using the access 2000.
Guess I'll just have to live with the deletions. If you think it would be hard Borg, then I don't stand a chance! LOL Thanks for your time!
|
|
Pay for your copy of WebWIZ, it's worth it and you know it!
|
|
Susan0722
Senior Member
Joined: 31 July 2003
Status: Offline
Points: 238
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 January 2006 at 3:08am |
How about this? Can I change the name of the old databse to something such as "archive" and run it that way? Of course I know I would have to change all the connection stuff in the pages.
But running a second similar database wouldn't interfer with the newest one would it?
I guess what I am saying is basically running 2 boards on the same site. However the old one I would lock all the forums so it can't be posted to, but just read only.
Would that work?
Edited by Susan0722 - 31 January 2006 at 3:13am
|
|
Pay for your copy of WebWIZ, it's worth it and you know it!
|
|
Susan0722
Senior Member
Joined: 31 July 2003
Status: Offline
Points: 238
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 January 2006 at 6:41pm |
The reason I ask the questions above is I remember reading something around here about cookies interfering with each other when tryign to run 2 boards on the same site.
Is there a fix for that?
|
|
Pay for your copy of WebWIZ, it's worth it and you know it!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 February 2006 at 9:35am |
|
For your archived forum you will need to edit the common.asp file with a text editor, from where you can disable the use of application variables and change the cookie prefix name. This should allow the forums to run side by side on the same site.
|
|
|
|
