Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantI replied to your ticket this:
Quote:I have replied to your Forums post.In the future please create either a Forums Post or a ticket. Not both! It is easiest to have the complete discussion in one place.
There is no difference between COMMUNNITY and ENTERPRISE in this respect. With MySQL server charset and client charset need not be the same. SQLyog will use utf8 on the client side no matter how data are stored on the server.
I am closing this ticket. We continues in the Forums!
.. but after replying to this I think the issue may be that you use a MySQL version (3.23 or 4.0) that does not support SET NAMES and UTF8 cleint charset.
Please tell:
What is the server version?
What is LOCALE setting in Windows?
What is the version and language of your Windows?
peterlaursen
ParticipantThis option has been removed becuase it is not required any more!
Please refer to:
http://webyog.com/faq/content/34/148/en/do…y-language.html
No mattter how data are stored on the server the client charset is now always utf8.
peterlaursen
ParticipantI told it was a mistake what I wrote first. We use Scintilla in the Editor tab – and for simple text display (in RESULTs/text, OBJECTs etc.) we don't – this is simpe code of our own. We need a full featured code editor for the Query tab (without it we would never be able to support autocomplete etc.)
Is the scroll issue you are reporting an issue with the editor, the GRIDS or the text tabs?
We have no plans to change scintilla with something else. I do not know if Notepad2 is fit (I once had a very old version that did not support unicode – so this version is definitely not). Also want a tool that depends on the Win32 API only (no foundation classes etc.).
Except for that I think I personally should not comment more on those code internals.
Due to MySQL UC this week don't expect more feedback this week on this!
peterlaursen
Participantok .. this was a new variation!
we have similar requests from people executing from a USB-stick/Flash card and from a user who wants to keep to everything containing passwords – whether 'obscurated' or not – on an encrypted drive (and who is not satisfied with the built-in NTFS encryption).
I think we have so many requests that we will have to consider ….
peterlaursen
ParticipantActually we have allready discussed displaying an explanation/warning about the meaning of USE in export dialogue + displaying in import dialogue something like “current database is **** – unless there are USE statements in the dump itself it will be executed against this database.
peterlaursen
Participantno .. currently it is not!
Please tell:
*why do you want to do this?
*what is the version you are using?
peterlaursen
Participantok .. let us discuss if the 'restore ..' option should be removed from the database context menu.
But SQLyog does not 'read' (parse) the content of an external file at all. We cannot display a warning. Also there may be more USE statments in a file (not one generated by SLQyog) so it is not enough to read the beginning of the file.
peterlaursen
ParticipantThis is a misunderstanding on your side, I believe!
When you import a dump it executes WHAT STATEMENTS ARE IN THE DUMP. If the DUMP contains the statement
Quote:use `firstdatabase`;.. it will of course do so! If the dump does not contain a USE statement it will import to the latest database selected in GUI.
Are you sure that the option to “include 'use' statement” was not checked when exporting and that the dump contained the USE statement?
peterlaursen
ParticipantIf I understanc correctly you can check/uncheck the 'top node for all tables'.
Please post a screenshot so that we agree what dialogue we are talking about!
peterlaursen
ParticipantData sync can run from anywhere.
It may give some performace boost to run on one a machine where one of the MySQL servers are. But not required – and not important either if you have a decent Internet connection. If only you can connect to the MySQL servers sync will run. Data sync is included in the free SJA for Linux as well as SQLyog Enterprise on Windows (including Wine). Windows version supports SSH and HTTP tunnelling, Linux version does not.
reading stuff:
http://webyog.com/faq/category/25/sqlyog-job-agent-sja.html
peterlaursen
ParticipantAre you referring to CSV import?
Please refer to changelogs for version 6.16.
“– Added an option to specify CHARSET parameter for CSV-import. Unicode (UTF8 and UCS2/UTF16) will be detected automatically. For files encoded with a non-unicode encoding, user must select the MySQL charset used for the import. Alternatively there is a
option that will not use the CHARSET parameter at all (= old program behavior).” and to understand that client character set and server character may be different read
http://webyog.com/faq/content/34/102/en/wh…-by-sqlyog.html
http://webyog.com/faq/content/34/148/en/do…y-language.html
The option to specify CHARSET with MySQL 'LOAD DATA' command was added recently (around 5.0.32 or so). We support that now.
The CHARSET option is a client-side specification. If SQLyog detects the file as UTF8 or UCS2 just let it be like that! The server will store as the database/table is defined but it will be decoded as specified with CHARSET option during import. It is a server functionality – not a SQLyog functionality.
peterlaursen
ParticipantPlease try 6.5x. Those dialogues were completely redesigned. Now you check/uncheck the 'table tree root node'.
peterlaursen
ParticipantIt was renamed from 'empty table' to 'truncate table'. 'truncate table' is the correct SQL term.
Did I understand correctly?
peterlaursen
Participanthmmm …
You get 'access denied'. This is NOT a HTTP/tunnelling problem. It is a MySQL authentication problem.
Please double-check you user accounts settings and the hostname (most often hostname is 'localhost' with HTTP tunnelling).
peterlaursen
Participantwe have contacted Share-It now and asked them to process this order or reply back if it not possible for some reason.
-
AuthorPosts