Sync Problem – Single Quotes

[Alan Sawyer]

I am trying to sync 2 MYSQL DB's, but I have some varchar fields that have single quotes in them. The sync is giving errors.

Is there something I can do to correct this?

Thanks,

Alan Sawyer

[peterlaursen]

What is the program version you are using?

I think I remember that this was fixed long ago.

With these data at source (note the escaped singlequote)

Code:

CREATE TABLE `pladder2` (
`id` bigint(20) NOT NULL auto_increment,
`t` varchar(50) default NULL,
`f` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `pladder2` */
insert into `pladder2` (`id`,`t`,`f`) values (1,'f',NULL),(3,'dd'f',NULL);

and those at target.

Code:

CREATE TABLE `pladder2` (
`id` bigint(20) NOT NULL auto_increment,
`t` varchar(50) default NULL,
`f` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `pladder2` */
insert into `pladder2` (`id`,`t`,`f`) values (1,'f',NULL),(3,'ddf',NULL);

it syncs OK like:

Code:

SQLyog Job Agent Version 5.1
Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.
Sync started at Thu Apr 06 19:58:17 2006

Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
`pladder2` 2 2 0 1 0

Total time taken – 1 sec(s)

So I think you should just consider upgrading you old program version!

[Ritesh]

Which version of SQLyog or SJA are you using?

[Author]

Posts