[johng]

Ritesh wrote on Jul 31 2006, 07:27 AM:

Have you considered creating the config. XML file manually?

Yes, what I now do is start the process in SqlYog to create the base XML file then I edit the XML. It's OK as a workaround for now.

[johng]

I am posting this because others might benefit who could be over-loading the system when migrating data to MySql from an ODBC data source (maybe just VFP but could affect others)

Upgraded to 5.15 and received the gone away error. Returned to version 5.01 and got same error but with a bit more detail:

ERROR: 2006, MySQL server has gone away

ERROR: [Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long.

Found out from various places that I was trying to update too many fields, or File DSN connection set to “Fetch data in background”. Looked at Options in ODBC setup, saw that “Fetch data…” box is unchecked which is correct. Tried again – no good. Table merge involves 145 fields so I used an XML editor to cut down the query by half (keeping the link field ID in the remaining script). 'Saved as' the new version to a new file. Then Saved as another version of the XML file and pasted the cut section + put the link field in that file as well.

Tried again – now it runs fine with two XML files. No problems.

[Author]

Posts