insert content from vexim mysql database to existing database

[Andrew Kerich]

Hi Guys,
I need to insert the vexim database content [users and domains] from one database A to database B.
This is to facilitate migration from one server to another.
The challenge is avoiding duplicate values in database B when inserting values from database A.

An excerpt of the insert code;
INSERT INTO `users` VALUES (2,2,'postmaster','[e-mail]','testing','*******',90,90,'/var/spool/mail/mydomain.com/postmaster/Maildir','/var/spool/mail/mydomain.com/postmaster','local',1,0,0,0,0,0,0,0,1,NULL,NULL,0,0,0,'Domain Admin',0,0,NULL,NULL);

I require an option that will increment the domain_id and user_id in the existing database. The domain id should be the same for user_ids for the same domain.

I was googling and the link below appears helpful but not assisted to solve the problem;

http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

pls assist.

Rgds,
Kerich