MySQL Data Compare bug report

Compares and synchronizes MySQL database content

Moderators: Chris Auckland, eddie davis, Michael Christofides

MySQL Data Compare bug report

Postby mmoore5553 » Tue Mar 13, 2012 9:14 am

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
 
Posts: 2
Joined: Tue Mar 13, 2012 9:12 am

Postby neil.anderson » Tue Mar 13, 2012 10:47 am

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
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby mmoore5553 » Tue Mar 13, 2012 2:48 pm

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
 
Posts: 2
Joined: Tue Mar 13, 2012 9:12 am

Postby neil.anderson » Tue Mar 13, 2012 6:09 pm

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
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm


Return to MySQL Data Compare

Who is online

Users browsing this forum: No registered users and 1 guest