Today I was betrayed by one of mnie SuperModerator by wiping more than 10,000 of its posts. The problem is that I do not have a recent back up but I have a backup of 4th October this year. Is there a possibility to somehow pull his posts from the old database and return them to the current?
SuperModerator wiped more than 10,000 of its posts
Collapse
X
-
Not very easily, you would be better off using the backup.My Mods also available at OzzModz.com
New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders!
Stop Spam Now The era of Big Spam is over.
Vote to bring back hooks in vB5, http://tracker.vbulletin.com/browse/VBV-10333 -
There is no supported way of doing this. May I suggest you edit moderator permissions in Admin CP to prevent Super Moderators (or anyone not an admin) from permanently deleting anything in the future.
In terms of unsupported ways, there would be no way to know which posts were deleted because of your supermod and which were deleted for legitimate reasons. you would wind up importing all posts since deleted for any reason.
Backup the database before you attempt.
I don't know the exact queries but I imagine if you copy the post and thread tables from the old backup, add them to the database as post2 and thread2 tables for example.
You would then need a query to copy the entire post from the post2 table to the post table where the postid exists in the post2 table but not in the regular post table.
Repeat for the thread / thread 2 table.
Then clear the cache, rebuild the forum and thread counters.
That should work,👍 1Comment
-
This may help - http://www.vbulletin.com/forum/forum...73#post2925973 It's about restoring deleted threads, but you may be able to change the queries for restoring threads/posts from a specific userid.
As always, test this on a test database first and make sure to do a database backup before doing it on the live site.
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css help👍 1Comment
-
Joe D., Lynne, thank you!
I'm not skillful with SQL Query. If it is not complicated and you have time to set aside, can someone write that query?
Edit?
Would this work?
Code:INSERT INTO DestinationDB..MyDestinationTable SELECT * FROM SourceDB..MySourceTable
Last edited by karabaja2; Tue 11 Nov '14, 3:11pm.Comment
-
Here's an accompanying thread at vb.org http://www.vbulletin.org/forum/showthread.php?t=294427👍 1Comment
-
Looking into this further, I don't think manual queries will be necessary if you have phpmyadmin.
1) Go to the Old Database in phpmyadmin. Export the post and thread tables. (Individually). For each export go to Advanced Options and check the box to use INSERT IGNORE statements.
2) Go to the New database (assumes you made a backup already) and IMPORT the SQL files for the post and thread table into the post and thread table in the new database.
3) Go to Admin CP -> Maintenance -> General Update Tools and run the update for Forums and then Threads, in that order.
👍 2Comment
Related Topics
Collapse
-
by spartan5I was deleting some posts of a page when I accidentally wiped out the entire thread!
Is there any way to bring back the information? I try to restore the thread from last backup, so:
...-
Channel: Support Issues & Questions
Thu 10 Sep '20, 2:19am -
Comment