[peterlaursen]

YES!

RC3 works as it should with these data. 😀

I tested with 3 different PK's

*field 'filnavn'

*field 'Guid'

*an autoincrement integer PK (that I wouldn't normally have with these data).

[peterlaursen]

I can say that it still does not work from GUI. But from commandline 1 of 3 tests completed succesfully.

The GUI-problem could be the same as the TRUNCATE-issue (failure to parse the XML ?)

[peterlaursen]

it's running now.

In the meantime I have an issue with the installation script. It deleted my collection of XML-files!

Does it just cleanup the folder ? It should only delete SPECIFIC files (yours), not MY files!

[peterlaursen]

Got it. I can spare about 45 minutes testing. That should be sufficient!

[peterlaursen]

I just checked the mail-server at my ISP. It is not there anymere.

[peterlaursen]

that explains …

I just received a mail (my mail-client is Outlook 2000), but Outlook crashed after receive and dropped it.

I must have been your mail. I haven't particularly safe security settings, so don't really understand.

If there are any attachments, have you zipped them ?

Alternatively let me download …

[peterlaursen]

Quote:

Did you receive my mail?

NO! Or I could have deleted it occasionally.

Did you use the gmail or the other ([email protected]) ?

Try the latter.

[peterlaursen]

Quote:

Its due to the data sturctures that we use internally

Yes, of course!

As of now I have two options

1) Wait 20 minutes for SQLyog to display SMALLTABLE

2) Close down SQLyog and restart it. It can be done in less than 10 sec.

What do you think I do ?

Using RESULT-pane as you suggest could be a solution in situations where is is important not to lose HISTORY.

[peterlaursen]

Quote:

my developers

If you OWN them just tell them what to do … or sell them! 🙄

(cheap enough and I might buy …)

I believe that it a common problem that people involved in the development proces and other people sometimes have difficulties in communicating. When you have been working with some stuff for weeks and months you easily forget that what is obvious to you is not to other people.

I believe GUI issues are an important part of BETA-testing.

We have had similar discussions on the “save to clipboard” and “export as CSV” – GUIs for instance.

[peterlaursen]

BTW (I continue asking ..)

jobfile says

Code:

GUI “Set Foreign_Keys_Check = 0 for target” is UNCHECKED.

To me this is the opposite world !?

How to understand this ?

[peterlaursen]

Here it happens like:

0) Start SQLyog

1) Create job-file using GUI

2) Save (don't run – don't schedule)

3) Open database sync. wizard again and choose the newly saved file

4) Step through and it displays as below

Jobfile content

Code:

localhost
******* ******* 3306 musik

http://www.deepeter.dk/SQLyogTunnel.php
30000

mydb1.surftown.dk
****** ****** 3306 jazcyk_test

`mp3_filer`
`Kunstner`

(UID and PW hidden)

[peterlaursen]

Did you produce the XML-file using the GUI ? I seems that it occurs when a job file is opened and saved again from GUI. Here the error actually “writes back” to the jobfile!

Code:

localhost
******** ******** 3306 musik

http://www.deepeter.dk/SQLyogTunnel.php
-2101821

mydb1.surftown.dk
******* ******* 3306 jazcyk_guestbook

`mp3_filer`
`kunstne`

and next open truncates once more:

(I shall try to produce a “straight” reproduceable case)

[peterlaursen]

For my part I must say that I step down from this question.

I'm not able to understand the exact nature of your problem.

[peterlaursen]

this for instance I would find much more logical.

I would have saved hours in my effort to understand it if only it was like that.

[peterlaursen]

I also wrote:

Quote:

I’d like a critical review of the XML generating GUI provided with SQLyog. Most

(graphical) objects here are too small to my taste. “Real life data” could have very long

identifiers/names and there could be dozens of columns with each table. When that is the

case the GUI is not optimal to work with as of now.

I can add that the GUI could be much more intuitive as far as use of and goes.

I'm thinking about the dialogue below in particular. I believe I can handle it now, but with the current doc's and GUI standard you will continue to see new users confused when getting to some more advanced use of the sync feature.

A detail: name of last column in the “columns column” of this GUI is truncated.

'kunstne' should be ''kunstner' (is in the XML-file).

[Author]

Posts