Unanswered: copy posts data into vbulletin backup (was "I need Help!")
Hello friends, I am new to this forums. I am having a Vbulletin Board installed. Unfortunately, my DB got corrupted. But I have the back up of the corrupted and of the normal DB. I managed to copy the values of new users registered after the backup date. But I want to cope one table which contions all the post data, so that the posts which were made after the backup the date.
that table name is userposts
I just want to copy this table and want to instert it into the DB which I backed up. I am sure that this table is ok and not corrupted.
INSERT INTO `backupdatabase`.`userposts`
SELECT * FROM `corrupteddatabase`.`userposts` WHERE ID NOT IN (SELECT ID FROM `backupdatabase`.`userposts`) AND `corrupteddatabase`.`userposts`.Date > '2007-05-01'
n.b. the above query limits the old resultset to a short while ago (2007-05-01) because I suspect you don't really want to test against the whole table (probably quite large) and your db corrupted recently so you should only bring back results that were recent.
Because I don't know the layout of your table for the userposts (nor can I be bothered to look it up for BB) so, the ID and Date fields I have used in the above query are quite possibly wrong and will need to be altered to whatever values you need.
I think I have just demonstrated a good example of social engineering. I now have the database(s) in question with usernames/email address/etc.
Granted the passwords are hashed/encrypted but it wouldn't take long to unhash them using the salt that is contained within the database once I find out what algorithm is used in the PHP for VBulletin.
DON'T hand out sensitive information over the internet in this fashion. Luckily for you I am honest chap and have no intention of utilising this information for "evil" purposes.