Backup and Restore user&passwords only

B

Ben10

New Member
Hi all

I hope all of you are ok .my forums 380 user are deleted by my coadmin now i wont to recover these users with their passwords from my old back up is there any way to recover user and password only not the whole backup ? i dont want to recover the whole backup because if i do this i lost 900 threads and 3 sub forums :S

Please help me in this thanks in advance .

sorry for my bad English
 
There is a way to do it (Maybe there are more, but i would use this one) :

Go to your phpMyAdmin, create a new database, call it whatever you want.
Import your backup into this new database you just made.
After its uploaded, go to it, and uncheck all the tables you dont want and scroll down the page, and look for words like - Drop Tables.
After that, you should be left with a table called "vb_user" or whatever your table prefix is.. when you have that one table hanging in there, go to the link with a word "Export", save it as .sql document somewhere on desktop or something.
Then go to your current forum database.
IMPORTANT NOTE: BACKUP YOUR CURRENT FORUM DATABASE TO CONTINUE WITH THE STEPS.
After backup of your forum db is successful, then view that database, and click button "Import", it will move you on the page with a button "Browse.." on it, hit it, and look for the .sql file with a table "vb_user" or whatever the name on your desktop..
Hit button "Go"...
NOTE: YOU MAY GET AN ERROR BECAUSE OF THE "ALREADY EXIST" COLUMNS.
NOTE: IF you dont want to get that error, you would have to remove the Line which phpMyAdmin tells that if that column already exist and reupload that .sql file again until it stops telling that there are errors.

Its hard but thats the way... =/
 
Thanks so much for your reply.i search for "vb_user" in my data base but found nothing i am using 3.8.2 there is a table in my forum data base called "users" ...

i tried this first i backup up user table from new data base then i restore user table in old database .it just shows users not login ..

can you explain me some more abt this
 
O_O never seen table users... cuz on my forum the table called vb_user
Since i chose the vb_ prefix, then the table must be called just "user" ..
 
hmm i found "user" table in database and restore in old data base but this only show users login not work ...:s
 
You must log in or register to reply here.
Back
Top