Printable View
I'm trying to import my user.sql database from an old forum I had a few months ago which is still online, I downloaded the user.sql file and I want to import it into my new forum, everytime I do this though it replaces all the current user members from userid 1-300 :( Is their a way to import the users without overwriting the current ones?
Also when this happens the new amount of members don't appear on the forums :(
I'd appreciate a quick response as vbulletin are taking donks these days.
Delete the id column + values from the insert sql - no idea if the data you'll import will be compatible since i'm assuming the SQL comes from a previous version.
Well, you can edit the .sql file, and change the ID's...
Say you have: 300 users already imported and your trying to import 200 OLD saved users (in the users.sql file) then, edit the SQL file (you'll have to edit every single ID)
The first user in the users.sql will be ID=1 right? Well, you have already in the DB ID=1, so you can't upload it (it'll go over it...) so, you have to change that ID=1 to ID=301 (since you have 300 users already uploaded) ETC!
It may be confusing, I have tried to do this (upload a forum DB to a ALREADY made forum DB) and it just fails, I'd say, THE BEST WAY, to leave it...
You can also try a Remote SQL, but I'd have to say, leave er alone xD
Or, you can do what Tomm said, which is much easier and will work due to the id column increasing.Quote:
Originally Posted by chadderbox25