Database question

hello guys,

I want transfer the content from old database to new database.

But my problem is, on the old database are members and on new database are members too and they beginns with 1. When i import the content i have error (profiles exist already)

how can i fix this problem? i need help please?

Simply changing the user id would break the old/new database as the user id is referenced in a few places. One could probably write a upgrade script to re-increment ids that exist already.

You also have to consider content from the old site; If you are going to throw away the content, blogs, photos, etc. then it won't matter.  If you just want the Profile table from the old database, then it will make it easier.  Of course any avatar or profile photo will be lost.  As far as the ID is concern, you just tell the old site members to log in with their user name until they learn their new ID; on my site, everyone goes by their user names and I would guess that most don't know their ID.

There are three fields that come to my mind that should not be identical between the two database Profiles tables, one is the ID, the second one is the user name, and the third is the email address.  Now the ID is generated by Dolphin and is basically an incrementation of the database field; and you will also need to set the ID increment to the new end value of the table after the import (I am not sure on this one, it may automatically update; the sql people will know for sure).  You need to make sure there are no user names in the new database that are the same in the old database and this goes for email as well; it is not likely that emails will be the same unless you have the same member on both sites; however, the email will need to be checked just the same.

If you are unsure about this, then hire someone with the skills to do it for you.

Thanks all for the answers.

But when i changing only the id number, than the avatars and photos are confused.

And how can i write a upgrade script to re-increment ids that exist already?

i am not php genius :-)