Date:  Tue, 15 Sep 2009 22:12:01 +0100
From:  Steve Howes <steve (at mark) geekinter.net>
Subject:  [coba-e:16034] Re: Restoring a record from a RaqBackup MySQL dump
To:  coba-e (at mark) bluequartz.org
Message-Id:  <38DCE975-F7B5-4B9D-AA46-16225AB4B10B (at mark) geekinter.net>
In-Reply-To:  <3B35D6D4B1B14E46BF31CB4130CF345A@HP9925NR>
References:  <3B35D6D4B1B14E46BF31CB4130CF345A@HP9925NR>
X-Mail-Count: 16034


On 15 Sep 2009, at 22:02, Darrell D. Mobley wrote:

> I have a website where a moderator mistakenly deleted a vBulletin  
> thread.  I have the MySQL database dump file from RaqBackup, which  
> runs every night.  I want to extract just that one record and  
> restore it on the server.
>
> What is the best way to do this?

It is not a single record. Its the thread, then the posts etc etc etc.  
Quite a lot of work. If vbulletin re-uses ID numbers (retarded but  
possible) that would hurt. You need someone familiar with SQL to go  
through the SQL dump.. Its just a standard MySQLdump so notepad would  
open it (slowly depending on size). Just need to fish out records, and  
related records. You'd have to read up on the schema but its probably  
guessable.

Steve