Whilst converting my 2.6GB postgres RT database 3.6.5 to mysql i get the following error.
[r...@bogan rt-3.6.5]# mysql -u root -p rt3 --ignore < /tmp/rt.sql6 Enter password: ERROR 1062 (23000) at line 34107989: Duplicate entry '242710-28171' for key 2 (line 34107989) INSERT INTO GroupMembers (id, groupid, memberid) VALUES (199352, 242710, 28171); Any ideas? Cheers, Kristian mysql Ver 14.12 Distrib 5.0.66a, for redhat-linux-gnu (x86_64) using readline 5.1 Further grep of the previous line too: INSERT INTO groupmembers (id, groupid, memberid) VALUES (199351, 242710, 28171); INSERT INTO groupmembers (id, groupid, memberid) VALUES (199352, 242710, 28171); mysql> desc GroupMembers; +----------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+---------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | GroupId | int(11) | NO | MUL | 0 | | | MemberId | int(11) | NO | | 0 | | +----------+---------+------+-----+---------+----------------+ >From prostgres rt3=# select * from groupmembers where groupid='242710'; id | groupid | memberid --------+---------+---------- 199351 | 242710 | 28171 199352 | 242710 | 28171 (2 rows) rt3=# \d groupmembers Table "public.groupmembers" Column | Type | Modifiers ----------+---------+----------------------------------------------------------- id | integer | not null default nextval('groupmembers_id_seq'::regclass) groupid | integer | not null default 0 memberid | integer | not null default 0 Indexes: "groupmembers_pkey" PRIMARY KEY, btree (id) _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com