Sync selected columns only error

[cactus]

I'm trying to do a one way sync from MySQL4.11 on windows to 3.23 on a linux web server. The tables all have timestamp fields.

The SQLyog sync tool reports an error that the timestamp fields are mismatched. I can't get them to match, which I think is due to the differences between 4.11 and 3.23 and the isp is unwilling to upgrade MySQL.

However, it would be acceptable to leave the timestamp column out of the synchronisation. The problem is that if I ask the sync tool to omit the column, I still get the same mismatch error. How can I get around this?

Hopefully,

Cactus Jon.

[peterlaursen]

I think you can't. Syncronization needs identical or at least “compatible” MySQL server versions. It's not only timestams that are problems. Did you try Sqlyog 4.06 RC1 http://www.webyog.com/forums/index.php?act…t=ST&f=2&t=1369 ??

Ver 4.0.x and 5.1.x won't sync either even if all fields are simple numbers and varchars.

It has this one new feature:

Quote:

SQLyog Job Agent now checks for MySQL versions compatibility during Data Synchronization. It will note continue if the implementation of concat_ws between the MySQL versions are found to be incompatible.

You can have more versions of MySQL installed and switching between then is quite easy with “MySQL Administrator”. Just correct the “configure service” and “starup variables” panes (4 strings need to be edited) and then stop and restart the server.

[Author]

Posts