Unable To Sync Data With Remote Site

[ukwiz]

I am trying to use database sync wizard to copy data from a local machine to a hosted machine.

SQLyog v5.16

Source MySQL version 4.1.13

Target MySQL version 4.0.27-standard

I created a table on the target using the structure sync tool. (why does this not create a table on the target?)

I then used the db sync wizard, selected all in the table select dialog, and got the following error:

Sync started at Sat Aug 05 13:42:02 2006

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

The server understood the request, but will not fulfill it. – Could not get FIELD information for '`userlist`' in the TARGET database

Check d:Program FilesSQLyog Enterprisesja.log for complete error details.

I then did the same, but selecting only the userlist table in the dialog box. This produced the following error:

Sync started at Sat Aug 05 13:28:45 2006

Could not get tables for the TARGET MySQL server

Check d:Program FilesSQLyog Enterprisesja.log for complete error details.

I tried a similar exercise using Navicat and the table was populated correctly.

Is this a known problem, or do I raise a ticket?

What more debugging can I do?

Regards

David

[peterlaursen]

Sorry for the late reply.

I do remember to have seen this before: “The server understood the request, but will not fulfill it. – Could not get FIELD information for …” It occured with a relatively old MySQL 4.1.x too and was not reproducable with 4.1.20. But I do not recall details.

Also we just verified that 4.1.19 (and 4.0.20 and 4.0.21) and 4.0.26 (and 4.0.27) syncs.

But it could also be an issue with a specific character set or data type.

Please create a ticket with some source data (only the problematic table with a few rows of data)

[Author]

Posts