database user post extraction

albertldee · #1 (**permalink**) 09-17-04, 10:47

please can anyone help me i have a ipb forum some how i accidently delete my post i have a old backup from 3 week ago how can i extract the post from the backup
NOTE: the only post that was deleted was post made by me none of the other member post was deleted
i did not want to restore the entire post table beacause i would loose post in the past 3 weeks
can anyone help me with a script or anything i can used to extract post of the post table where the poster id is 1
here is a sample

INSERT INTO `ibf_posts` VALUES (2, 0, NULL, 1, 'albertldee', 1, 1, '12.8.34.199'
INSERT INTO `ibf_posts` VALUES (3, 0, NULL, 4, 'Þ®ÍÑ¢ê-ÄÑ¤', 1, 1, '207.44.154.35
INSERT INTO `ibf_posts` VALUES (4, 0, NULL, 6, 'demarcus', 1, 1, '69.142.131.149
INSERT INTO `ibf_posts` VALUES (5, 0, NULL, 7, 'gottasteu', 1, 1, '65.12.169.41

the post table has about 122000 line like above i just want to extract all the line that has albertldee like line number 1

LKBrwn_DBA · #2 (**permalink**) 09-17-04, 13:13

Try something like:

Code:

INSERT INTO ibf_posts 
SELECT * FROM ibf_posts_backup
 WHERE user_id = 'albertldee';

NOTE: Change user_id to the correct column name.

albertldee · #3 (**permalink**) 09-17-04, 23:49

thanks but how do i set it up

albertldee · #4 (**permalink**) 09-18-04, 09:12

or can anyone tell me how can i setup a query to check a table and insert a line if it's not already exist

LKBrwn_DBA · #5 (**permalink**) 09-20-04, 09:12

Post a description of both the 'ibf_posts' and the backup table.

Internet Services

Web Development

Digital Marketing

Consumer Tech