Announcement

Collapse
No announcement yet.

SuperModerator wiped more than 10,000 of its posts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] SuperModerator wiped more than 10,000 of its posts

    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?

  • #2
    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

    Comment


    • #3
      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,

      Comment


      • #4
        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

        Comment


        • #5
          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
          Or can I use Oracle SQLDeveloper to work with exported MySQL databases using "Import Data" task?
          Last edited by karabaja2; Tue 11 Nov '14, 4:11pm.

          Comment


          • #6
            Here's an accompanying thread at vb.org http://www.vbulletin.org/forum/showthread.php?t=294427
            Kind regards,
            Simon
            Microsoft Office Discussion

            Comment


            • #7
              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.

              Comment


              • #8
                I did exactly as you explained. I managed to restore into base 10,200 posts. Almost all of them. I am very pleased. I am very grateful for your help and effort to explain procedure.

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X