How can we help you today? How can we help you today?

MySQL Data Compare bug report

I have sent an email to your company but never heard and answer so trying here ... I need to get missing data out of the db. Also this is just going to migrate it over and keep the new stuff right ?

here is the error

Bug report generated at 3/13/2012 4:08:17 AM
Program version 1.0.0.351
System.Exception: When deploying couldn't execute the statement:SET @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (2, 1, 10, 1270390602);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (3, 1, 13, 1276891714);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (5, 1, 18, 1270390586);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (6, 1, 33, 1295320081);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (7, 1, 45, 1270390608);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (8, 1, 61, 1270390592);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (9, 1, 67, 1315961635);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (10, 1, 80, 1275877721);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (11, 1, 93, 1270434534);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (12, 1, 127, 1271096872);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (13, 1, 129, 1284475491);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (14, 1, 130, 1271725893);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (15, 1, 131, 1271725886);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (17, 1, 133, 1271733515);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (18, 1, 134, 1271734690);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (19, 1, 135, 1281463558);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (20, 1, 137, 1272912143);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (21, 1, 138, 1294025904);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (22, 1, 167, 1273456074);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (23, 1, 173, 1273592087);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (24, 1, 175, 1277839308);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (25, 1, 185, 1273717586);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (26, 1, 193, 1273851089);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (28, 1, 201, 1274283153);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (29, 1, 222, 1276164038);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (30, 1, 223, 1275410055);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (32, 1, 225, 1275434240);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (33, 1, 229, 1275502322);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (34, 1, 230, 1275601546);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (35, 1, 231, 1275604153);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (36, 1, 234, 1275620600);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (37, 1, 235, 1275675031);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (38, 1, 238, 1275706696);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (39, 1, 242, 1275706718);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (40, 1, 251, 1275706733);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (41, 1, 253, 1275756174);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (42, 1, 258, 1275756220);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (43, 1, 266, 1277219117);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (44, 1, 275, 1275756378);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (45, 1, 277, 1275756359);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (46, 1, 298, 1275869970);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (47, 1, 319, 1276860363);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (48, 1, 326, 1276309513);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (49, 1, 330, 1276508826);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (50, 1, 331, 1276481129);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (51, 1, 336, 1317673944);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (52, 1, 339, 1276539240);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (53, 1, 350, 1276794235);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (54, 1, 404, 1277407710);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (55, 1, 407, 1277425186);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (56, 1, 422, 1293906923);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (58, 1, 445, 1277764028);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (59, 1, 453, 1277920681);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (60, 1, 460, 1280264856);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (61, 1, 478, 1278819205);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (62, 1, 504, 1279652536);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (63, 1, 514, 1279926398);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (64, 1, 516, 1279984115);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (65, 1, 521, 1281452610);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (66, 1, 587, 1281553993);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (67, 1, 594, 1281720163);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (68, 1, 601, 1308571928);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (69, 1, 625, 1282511747);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (70, 1, 629, 1282603510);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (71, 1, 637, 1282879660);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (72, 1, 672, 1283792720);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (73, 1, 702, 1283916609);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (74, 1, 713, 1283916332);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (75, 1, 821, 1284487582);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (76, 1, 868, 1285524888);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (77, 1, 875, 1285524896);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (78, 1, 917, 1285616540);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (79, 1, 926, 1285779315);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (80, 1, 936, 1285779330);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (81, 1, 966, 1285959326);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (82, 1, 1018, 1286665021);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (83, 1, 1021, 1286587962);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (84, 1, 1025, 1308432961);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (85, 1, 1041, 1286903634);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (86, 1, 1113, 1287520733);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (87, 1, 1114, 1303831701);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (88, 1, 1123, 1287607177);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (89, 1, 1141, 1293830681);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (90, 1, 1152, 1287848834);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (91, 1, 1244, 1288749989);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (92, 1, 1263, 1289248129);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (93, 1, 1292, 1289248081);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (94, 1, 1339, 1289248078);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (95, 1, 1489, 1291575248);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (96, 1, 1501, 1291005264);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (97, 1, 1526, 1291508183);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (98, 1, 1543, 1291508252);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (99, 1, 1591, 1292200574);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (101, 1, 1712, 1294285913);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (102, 1, 1721, 1294862593);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (103, 1, 1732, 1294862601);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (104, 1, 1746, 1295145779);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (105, 1, 1750, 1302422729);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (106, 1, 1758, 1295324140);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (107, 1, 1837, 1298341274);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (108, 1, 1847, 1298341276);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (109, 1, 1853, 1298341275);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (110, 1, 2015, 1300922746);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (111, 1, 2288, 1303870470);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (112, 1, 2385, 1305078896);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (113, 1, 2392, 1305326503);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (114, 1, 2568, 1317318235);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (115, 1, 2658, 1316193991);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (116, 1, 2774, 1309743911);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (117, 1, 2776, 1310248665);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (118, 1, 2777, 1319558492);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (120, 1, 2822, 1310441948);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (121, 1, 2823, 1310537924);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (122, 1, 2824, 1315783907);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (123, 1, 2856, 1316268718);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (125, 1, 2879, 1310694521);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (126, 1, 2893, 1313346153);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (127, 1, 2943, 1312149386);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (128, 1, 2996, 1319404101);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (129, 1, 3113, 1316617159);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (130, 1, 3120, 1313449146);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (131, 1, 3162, 1313960386);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (132, 1, 3202, 1314637482);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (133, 1, 3203, 1315442400);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (134, 1, 3265, 1324307422);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (135, 1, 3267, 1315783907);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (136, 1, 3305, 1315755376);
 ---> Duplicate entry '1-175' for key 'ukey'
   --- End of inner exception stack trace ---
   at #2jmb.#1jmb.#um()
   at #5jmb.#4jmb.#kFc.#zmmb()
   at RedGate.Shared.Controls.ProgressDialogEx.e()
mmoore5553
0

Comments

3 comments

Sort by
  • neil.anderson
    Hi mmoore5553,

    Sorry you didn't get a reply to your bug report, did you send it to the mysql mailbox mysql@red-gate.com?

    The data comparison tool attempts to bring the two databases inline so by default it will try to drop data that is only in the target. At the comparison grid you need to uncheck the rows that are only present in the target in order to have MySQL Data Compare leave those rows alone.

    Can you post the schema of the table you are comparing (`xf_cz_group_member`) here? I suspect there are multiple keys on that table and selecting an alternate one to use during the comparison might help.

    FYI there are forums just for the MySQL tools:

    http://www.red-gate.com/MessageBoard/vi ... .php?f=119
    http://www.red-gate.com/MessageBoard/vi ... .php?f=146

    Regards,
    Neil
    neil.anderson
    0
  • mmoore5553
    I am sorry but you can move this to the appropriate forum.

    Yes i sent it to who the program sent it too. Also what do you mean on grabbing it ? How can i do that or the steps please.

    I have tried other programs but they do not show me what is in the table so it is hard for me to tell if it is working or not.
    mmoore5553
    0
  • neil.anderson
    Hi,

    To get the table schema you can run the following command SHOW CREATE TABLE tbl_name in a tool such as MySQL workbench.

    Neil
    neil.anderson
    0

Add comment

Please sign in to leave a comment.