Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
By mistake I deleted a topic!
Avatar
Apopas
Member
sp_UserOfflineSmall Offline
Feb 15, 2017 - 2:19 pm

Help! As the title says, instead of deleting a post, I deleted the whole topic! surprised

Is it possible to recover it??? Please say YES!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 15, 2017 - 3:00 pm

Currently, I am afraid, only with a complete database restore. We have some work in progress to create a 'trash' system but it ain't there yet I am sorry to say...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Apopas
Member
sp_UserOfflineSmall Offline
Feb 15, 2017 - 3:08 pm

OUCH!

This will delete every forum post, every blog post, every comment, every user in the site and in general every change that took place after the backup of the database?

Can I restore only the forum's database?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 15, 2017 - 3:52 pm

You could try just restoring the sfposts and sftopics tables (which will still lose every post & tropic made since the backup was made). There may well be other knock-ons that I have not considered however and generally I would not recommend it.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Apopas
Member
sp_UserOfflineSmall Offline
Feb 15, 2017 - 4:28 pm

This topic had over 11000 posts...frown

And what is the irony? I knew that the "delete this topic" option of the toolset was very dangerous and was trying yesterday to remove it without success and planned to ask here today how to do it.

One week ago I had copied (by ftp) whole the httpd folder. I suppose it does not include the database as well... Correct?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 15, 2017 - 6:01 pm

No - the database is completely separate.
The 'delete' tool does ask for your confirmation...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Apopas
Member
sp_UserOfflineSmall Offline
Feb 15, 2017 - 8:39 pm

Yes, but I thought I had clicked the "delete this post" option.

 

So now I have an old database backup. What could I do to get the less possible damage?

If I create a second forum inside my site, can I restore sfposts and sftopics tables in that forum without touching the original one?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 15, 2017 - 9:20 pm

1100 posts in one topic?  Wow.

No, you can only have one forum per site.

How much activity have you had since the deletion??  Easiest thing to do is restore that backuo and lose recent stuff.  If lot, that is problematic.

Issue is you need more than just topics and posts table. There will be some manual steps either way.

We still have it on our list to add a tray feature so even if you confirm the deletion you still have another check.

Avatar
Apopas
Member
sp_UserOfflineSmall Offline
Feb 15, 2017 - 9:51 pm

No 1100. 11000 cry This topic was 5 years old.

In my forum I have only a few topics and I never (intent to) delete them. The users do not have permission to create a new one, so every activity takes place inside these few topics.

My biggest topic is 34000 posts strong for example. The topic I deleted was the second biggest one.

The backup is much older than the deletion, that's why a complete restore is not an option.

I'm thinking to create a subdomain, restore there my old backup, delete everyting but this topic and link this specific topic to my original site. Could that work?

What else could I do?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 16, 2017 - 4:47 am

yes - I see no reason why you could not do that. Sub-domains are no problem.

What I was getting at yesterday is that after you clicked on the toolbox menu to delete the topic, you must have also then said OK to the confirmation dialog - it is a two stage process.

Ah - 0ne word of caution. Always remember that if you create a new sub-domain the database name has to be different to the original, still existing database. Depending on how you decide to restore the old DB it may try and create a new database with the same name. That will fail or even overwrite your current one. Unlikely but something to bear in mind.

And I can't stress enough. Everyone running a website with a database needs to make regular backups. Weekly is probably the minimum frequency with which it should be done.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10120
Posts: 79607