wont compare some columns

Compares and synchronizes MySQL database content

Moderators: Chris Auckland, eddie davis, Michael Christofides

wont compare some columns

Postby va2dos » Tue Nov 15, 2011 3:23 pm

Hi there, I have some column when i compare with MySqlCompare they show has identical, but when i try to sync the data, it refuse to compare some varchar field marked with a yellow (!) sign w/o any other indications

here's the Table creations script and a screen shot of mySqlCompare

CREATE TABLE `rabbids_sb`.`share_definition_message` (
`id` int(10) NOT NULL auto_increment,
`share_definition_id` int(10) NOT NULL DEFAULT 0,
`title` varchar(100) NOT NULL DEFAULT '0',
`description` varchar(100) NOT NULL DEFAULT '0',
`image` varchar(100) NOT NULL DEFAULT 'shareimage_test.png',
`link` varchar(100) NOT NULL DEFAULT 'StartPlaying_Link1',
PRIMARY KEY (`id`),
CONSTRAINT `fk_share_definition_message_def_id` FOREIGN KEY (`share_definition_id`) REFERENCES `rabbids_sb`.`share_definition` (`id`),
KEY `fk_share_definition_message_def_id`(`share_definition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Image[/img]
va2dos
 
Posts: 1
Joined: Tue Nov 15, 2011 3:15 pm

Postby neil.anderson » Tue Nov 15, 2011 4:32 pm

Hi va2dos,

I've contacted you via email to get some more info.

Thanks,
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