won't compare some columns

Compares and synchronizes MySQL database content

Moderators: Chris Auckland, eddie davis, Michael Christofides

won't compare some columns

Postby jlu » Wed Jan 25, 2012 4:12 pm

Hi there, I have the same issue as someone previous reported:

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.


I did not see any solution from the previous response, so how can I work around this issue????
jlu
 
Posts: 3
Joined: Wed Jan 25, 2012 4:02 pm

Postby neil.anderson » Thu Jan 26, 2012 9:53 am

Hi jlu,

The previous reporter of the issue and I were not able to recreate the problem. Can you send us the schema of the tables you are comparing and the versions of the instances of MySQL please?

You can post the info here or send it to mysql@red-gate.com

Thanks for your report,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby jlu » Thu Jan 26, 2012 1:34 pm

Hi Neil,

This is what is being shown from MySQL Compare in both the left (v5.5 DB instance) and right (v5.1 DB instance) side of the screen, they are identical:

CREATE TABLE `ALERT_Engines` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(256) NOT NULL,
`ALERT_Engines_Categories_id` int(11) NOT NULL,
`alert_title` text NOT NULL,
`alert_title_commercial` text NOT NULL,
`commercial_only` int(11) NOT NULL DEFAULT '0',
`alert_display` tinyint(4) NOT NULL,
`alert_display_order` int(11) NOT NULL,
`alert_description` text NOT NULL,
`alert_description_commercial` text NOT NULL,
`requires_channels` tinyint(4) NOT NULL DEFAULT 0,
`type` varchar(50) NOT NULL,
`admin` tinyint(1) NOT NULL,
`all_users` tinyint(4) NOT NULL DEFAULT 0,
`defaultstate` int(11) NOT NULL,
`sleeplength` int(10) NOT NULL,
`sendfrequency` int(10) NOT NULL,
`lurk` tinyint(1) NOT NULL,
`enabled` tinyint(4) NOT NULL DEFAULT 1,
`offset` int(3) NOT NULL DEFAULT '0' COMMENT 'in days',
`uses_appliance_table` tinyint(2) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 row_format=COMPACT AUTO_INCREMENT=27


From MySQL Data Compare, under the tables tab, in the row "ALERT_Engines" the right column "Columns in Comparison" has "19 of 23 columns". When I click it, there are four ! marks in yellow triangle, it looks like:

[code]
Int offset !
TinyInt uses_appliance_table !
! offset Int
! uses_appliance_table TinyInt
[/code]


j[/img]
jlu
 
Posts: 3
Joined: Wed Jan 25, 2012 4:02 pm

Postby jlu » Thu Jan 26, 2012 1:43 pm

I am not sure if that matters, the offset and uses_appliance_table columns were added after the creation of the tables. IE, when I first run MySQL Compare 1 and MySQL Data Compare 1 on this table, these columns didn't exist. After the columns were added, I re-ran MySQL Compare 1 and it showed identical schema, but when I re-ran MySQL Data Compare 1, I cannot compare the new columns.
jlu
 
Posts: 3
Joined: Wed Jan 25, 2012 4:02 pm


Return to MySQL Data Compare

Who is online

Users browsing this forum: No registered users and 1 guest