[peterlaursen]

I am sorry and you were right. 🙁

Add 'log_bin' to the [mysqld] section of my.ini/my.cnf or start the server with '– log-bin' option from shell. It is the same.

Yes, I would like the option to save or rather 'spool' HISTORY too. If you occasionally close the program (or if it crashes), you will lose HISTORY as of now. But I don't think it is very easy to implement now – that should have been 'concepted' like that from the beginning.

And I then would also repeat the requests that:

1) a semicolon is added to each line of HISTORY

2) there should be an option not to write the TIME information.

[peterlaursen]

The old discussion I referred to was this one:

http://www.webyog.com/forums/index.php?sho…65533;entry8732

In the JPG that I uploaded I highlighted the two succeeding CR-characters, so it should be plain to see.

[peterlaursen]

The option to save or 'spool' HISTORY to a file (and open it in HISTORY next time SQLyog is started) has been requsted before. By me-myself too! 🙂

Quite a few programs have an option to set the logfile size. When a new entry is added the oldest is removed. WINDOWS own system logging does this. Symantec AV program and others do.

With the MySQL Server you can enable binary logging if you have privilege to access the configuration. simply add “bin-log” to the configuration file. It will record any operation just like a tape recorder (of all users and all connections). There is a tool available from MySQL that lets you convert the binary log to a plain text file. There is a 'whitepaper' on that from http://www.mysql.com.

I think with MySQL 5.1 you will also be able to save the binlog in database itself. Did not have the time to research into that yet …

[peterlaursen]

I simply exported the table from right-click in OBJECT BROWSER. No BULKs were chosen (but this has no efect due to a bug in the BETAs till now).

Didn't I attach the dump file.

I see the double CR-CR sequence too in BACKUP 'powertool'. It happens with all data and all settings

The double CR-CR sequence is the problem as things messes up (makes things difficult to read) in some editors! This has been there for a long while. All the time I have been using SQLyog, I think.

[peterlaursen]

The issue is the same as another user also has reported, but seems 'forgotten in the hush'.

The CR-LF sequence is erroneously written like CR-CR-LF (or HEX '0D 0D 0A').

NOTEPAD ignores this double CR-CR sequence – other editors (such as my favorite TEXTPAD) don't. Due to this the 'arrangment of linebreakings' becomes a mess in TEXTPAD.

A simple dump attached and a screenshot of how it displays in a HEX-editor.

[peterlaursen]

But if I understand you right, they don't disappear permanently?

[peterlaursen]

Quote:

i tried to start again and connect to the same DB … etc …and tried for the 3rd time on the external DB, and now it worked again.

Looks like 'it' tries to use an (old) client thread that is no longer available and not create a new one.

If so I think 'it' must be the server! If server refused connection SQLyog would report that. However Server does neither refuse or allow connection. Nothing happens .. and SQLyog just waits and waits as it has not been told to quit.

If I remember details right this has only occured with the most recent MySQL server versions (5.0.18 and 5.0.19 for instance?). Could be a server issue, that Server assigns the connection to a thread that cannot be used. Some kind of concurrency issue with the server code itself and the most recent builds???

Just a guess …

[peterlaursen]

@ritesh

I think you are mistaken to one point! It is about the native Windows UNICODE implementation. Win NT/2K/XP does not use UCS-2 but UTF-16 internally. The help file on my system reads (in Danish):

Quote:

En tegnkodningsstandard udviklet af Unicode Consortium, der kan gengive næsten alle skriftssprog i verden. De tilgængelige tegn i Unicode kan repræsenteres i forskellige formater, herunder UTF-8, UTF-16 og UTF-32. I de fleste Windows-grænseflader benyttes UTF-16.

Last paragraph translates to 'In most Windows interfaces UTF-16 is used.' I don't know about the 'unicode layer' in Win98SE. It could be UCS-2. But UCS-2 is mostly considered depreciated.

Read: http://en.wikipedia.org/wiki/UTF-16:

Quote:

UTF-16 is the native internal representation of text in the Microsoft Windows NT, Windows CE, Qualcomm BREW, and Symbian operating systems; the Java and .NET bytecode environments; Mac OS X's Cocoa and Core Foundation frameworks; and the Qt cross-platform graphical widget toolkit.

I don't know if it makes any difference as far as SQLyog 5.2 goes!

[peterlaursen]

Did you reboot your PC after SQLyog was installed?

We just had another similar situation where this did the trick!

(this is only an experiece – not an explanation!)

Did you try SQLyog 5.02? Any problems here?

[peterlaursen]

Code:

data that is not being updated, dissapears!

Could you explain what is precisely 'disappears' ? Is it (only) this:

I can do a select on data that should not have been updated by SQLyog and it returns 0 rows, after a few secconds, its there again.

And after that there are no problems?

I think it looks mostly like a MySQL issue of some kind. Like MySQL operates some temporary tables internally. Or does it lock access? What is the MySQL version? On what platform?

[peterlaursen]

That is fine with me …

As I wrote elsewhere it is all things that must be fixed 'on the road to 5.2'. Exactly when and in what order is much a planning issue ..

And as Nick made it clear, it is posible now to 'localise' the Editor with the 'non-unicode' setting from Control Panel and the 'script' setting from SQLyog preferences. It is a minor thing that OBJECTS and HISTORY don't display right. To write localized comments you can then manually write an ALTER TABLE statement in editor.

The main thing is that we all understand what happened and what must happen!

[peterlaursen]

The customer could/should run a STRUCTURE SYNC before DATA SYNC.

However still the STRUCTURE SYNC could be implemented in the SJA.

But the risk is that he syncs to the wrong database and completely destroys it!

There are workarounds, for instance:

* you upload the latest 'create statement for the table' to somewhere

* he downloads it and creates an empty database

* he STRUCTURE syncs changes from this empty database to his production database

* now he can do the DATA SYNC

[peterlaursen]

hmmm .. I think it could be a little bit dangerous that way!

DATA SYNC needs totally identical tables. This protects against a completely 'mad' and mistaken sync operation.

What you request is actually that STRUCTURE SYNC is implemented in the SJA as well. And that is no bad idea – but there are some security concerns ….

[peterlaursen]

No issue …

Nick's Turkish example was a good exercise. There are a handful of things that must be fixed 'on the road to 5.2'. Exactly in what order is much a matter of planning resources.

Thanks to Nick we can now describe how to handle 'non-latin1' data whether single-byte on multi-byte as long as only 'one set of nationals' are involved. I'll do that in the FAQ when I see the exact implementation of the soon-coming RC(s)

[peterlaursen]

I'll work on some examples of 'badly formatted dumps' tomorrow!

[Author]

Posts