How to retrieve one thread from backup DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mansour
    Member
    • Aug 2003
    • 62

    How to retrieve one thread from backup DB

    Hello

    One of my member was completely deleted a thread (Mistake Action), its not in our DB any more.
    I have a backup for the DB, and I want to know how I can retrieve this thread and insert it into the current DB.

    I know its a complicated procedure, and most of steps are SQL queries, but the thread is very important and I have to go with this option.

    Any help ?
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    I haven't tested this.

    Restore the backup to a new database. Browse the thread and post tables using a program like phpmyadmin. Prune all records in those tables except for ones with a threadid corresponding to the deleted thread. Make a data dump of those tables and restore that dump to your live database. Backup your live database before doing this.

    After the restore, you will likely need to rebuild your thread and forum info:

    Admin CP -> Maintenance -> Update Counters

    If the thread had attachments, this will not restore them. Look to the attachment table.

    Comment

    • dodgechargerfan
      Member
      • Aug 2005
      • 70
      • 3.6.x

      #3
      Just to let you know: I tried this and it works.

      Thanks!

      Comment

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