MySQL Data Compare bug report

mmoore5553mmoore5553 Posts: 3
edited August 1, 2017 9:19AM in MySQL Data Compare
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()
· Share on Twitter

Comments

  • neil.andersonneil.anderson Posts: 64
    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
    · Share on Twitter
  • mmoore5553mmoore5553 Posts: 3
    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.
    · Share on Twitter
  • neil.andersonneil.anderson Posts: 64
    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
    · Share on Twitter
Sign In or Register to comment.