PDA

View Full Version : DB error on users


level8
05-03-2010, 07:16 PM
I backed up my 3.8 version using myPHPadmin then uploaded vbulletin 4.

This I gave a new mySQL db.. so I have now got 2 mySQL databases.

I dont need my old forums structure just the users... I have copied the table.user across which got all my old users across but i cant change password etc.. as it gives a db error.

Is there a way I can copy these users across or export (from old db) and import (new db)... ive tried but keep hitting errors.

Angel-Wings
05-03-2010, 10:48 PM
Why not just use Impex to import the users from your old board to the new one ?

level8
05-04-2010, 06:05 AM
whats impex and how does that work...

i just tried importing the old mysql into myphpadmin and its just killed everything... WHOOPS

legacy123
05-04-2010, 09:35 AM
Impex is the database import system provided by vbulletin which can be found at http://members.vbulletin.com

Marco van Herwaarden
05-05-2010, 09:34 AM
You can not just copy over a few tables from 1 installation to another. User information is already stored in many tables and tables reference eachother.

If you want to start clean, then ImpEx is the way to go.