Red Gate forums :: View topic - MySQL Data Compare bug report
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Data Compare
MySQL Data Compare forum

MySQL Data Compare bug report

Search in MySQL Data Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
mmoore5553



Joined: 13 Mar 2012
Posts: 2

PostPosted: Tue Mar 13, 2012 9:14 am    Post subject: MySQL Data Compare bug report Reply with quote

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()
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Tue Mar 13, 2012 10:47 am    Post subject: Reply with quote

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/viewforum.php?f=119
http://www.red-gate.com/MessageBoard/viewforum.php?f=146

Regards,
Neil
Back to top
View user's profile Send private message
mmoore5553



Joined: 13 Mar 2012
Posts: 2

PostPosted: Tue Mar 13, 2012 2:48 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Tue Mar 13, 2012 6:09 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group