Title: PHP data base
Post by: twl_viper on August 08, 2008, 02:25:15 AM
Post by: twl_viper on August 08, 2008, 02:25:15 AM
one of my web site admins deleted one of my long time 3 year members on my forums - I thought it was himself and after not receiving anything from him for a month just assumed he wanted to be deleted. which is unfortunate because he had over 300 posts over the years. Just found out from him that it wasn't him and someone deleted him.
I have an old php database backup - is it possible to restore a single member and all his associated posts - or do I have to loose a month or so of data?
anybody know?
thx
I have an old php database backup - is it possible to restore a single member and all his associated posts - or do I have to loose a month or so of data?
anybody know?
thx
Title: PHP data base
Post by: Elgan {sfx} on August 08, 2008, 11:01:43 AM
Post by: Elgan {sfx} on August 08, 2008, 11:01:43 AM
yeah sure but i cant give you exact code to run in phpmyadmin as i dont know what your sql database or even if your using sql.
if its mysql. Basically you need to find the user table. Then you need to search the name column for his name. THen once u find him. get his ID. Then extract all data from tables where his ID match in user id colums. Then export that data.
another way might be to work it so it imports everything again but ignored any duplicates. It will restore any setting and things deleted since tho.
if its mysql. Basically you need to find the user table. Then you need to search the name column for his name. THen once u find him. get his ID. Then extract all data from tables where his ID match in user id colums. Then export that data.
another way might be to work it so it imports everything again but ignored any duplicates. It will restore any setting and things deleted since tho.
Title: PHP data base
Post by: twl_viper on August 08, 2008, 06:32:23 PM
Post by: twl_viper on August 08, 2008, 06:32:23 PM
yes its sql - all i see is the option to upload the db, and warns it will replace all current data
Title: PHP data base
Post by: JoeyC on August 09, 2008, 01:54:22 AM
Post by: JoeyC on August 09, 2008, 01:54:22 AM
Viper are all his posts still in the forum ??. They should still be there I think only the user name would be guest or anonymous. If that is the case just insert his user name id back into the username tables and it should work like elgan said. And always always make a backup of the current db and site before messing around with mysql.
Title: PHP data base
Post by: twl_viper on August 09, 2008, 08:09:12 AM
Post by: twl_viper on August 09, 2008, 08:09:12 AM
no all his posts were removed - i tried to restore the whole db to 1 month ago - but nothing happened. Im not really familiar with this stuff.
Title: PHP data base
Post by: JoeyC on August 10, 2008, 11:29:22 AM
Post by: JoeyC on August 10, 2008, 11:29:22 AM
If you are not worried about losing info from the time his account was deleted then you have to drop all tables then upload the old database, remember going back to the old db will cause a problem to anyone new that registered since that time. Or if you want to keep the current db then add his account back you have to find his name and id and all the posts he made, insert his name and id back in the users table, then in the bbposts table of the db you have to use the insert and copy and paste the values out of the old db. Parsing through a db is a pain in the ass. Alot of work trying the adding route. But remember to backup the current db. Maybe contact your provider maybe they will help. Only other way would be to give access to your cpanel to someone you trust and has good knowledge of sql. Hope this helps shed some light 