Quotes In Data

[Alan Sawyer]

Trying to sync a couple mysql db's that have single quotes in the data that are “escaped”.

For example one of the varchar fields contains

This is why it's so important

I don't have control over the data since it's being written to by a php program that was purchased.

Is there a way to have sqlyog not have a problem when syncing this data?? I'm assuming that sqlyog is probably trying to escape the data again, or something.

I own SQLYog Enterprise.

Can anyone help?

Thanks,

Alan Sawyer

[peterlaursen]

No problem here

A simple table id: integer PK, t varchar(50) 'This is why it's so important`on source and 'This is why it's so important' on target syncs like

Code:

SQLyog Job Agent Version 5.1
Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Tue Apr 11 18:38:08 2006

Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
`a` 1 1 0 1 0

Total time taken – 0 sec(s

)

…and data are OK afte sync.

We fixed an issue with backslashes LONG ago (4.06 or 4.07 – that is a year ago). What is your version?

And could you please desribe more is detail what is the problem you experience?

[Alan Sawyer]

Using 5.02.

I went back to try to make sure I wasn't seeing things, because I'm wanting to sync a remote db and a local one, but now I'm getting a

NULL definition mismatch for 'ckey' column in '`pycategory`' table

error message. I am running mysql 4.x on the remote server and mysql 5 on my local windows computer, but the structure sync wizard says there are no differences in the tables. I have 2 tables.

This may be something I'm doing, but I'm not sure.

I could send you both db's if that would make sense.

Thanks,

Alan Sawyer

[peterlaursen]

You cannot sync 4.x and 5.0. http://www.webyog.com/faq/11_68_en.html

@Ritesh: why does it not find that those versions are incompatible? It should! I have seen that a few times now!

[Alan Sawyer]

Thanks, I didn't know that.

I will try to uninstall 5 on my local windows computer and install 4 and then see how it works.

Thanks again,

Alan Sawyer

[Alan Sawyer]

I ended up copying my server db that was in mysql4 to my local server which has mysql5 and doing the sync from there. That worked well, but I was wondering if there was a way to see what data was changed??

For example, what fields were changed and with what data??

Thanks,

Alan Sawyer

[Author]

Posts