Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantIn short:
1) if you can ensure to have a unique column or set of unique columns (in addition to the Primary Key) you can specify this/those with the
options in data sync. (it does not matter for SJA if a unique key is defined – only if you know a column or set of columns that are unique you should those with the specification as this will speed up checksum calculations. If not possible at least specify excluding big BLOBs/TEXTs) 2) have a TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP in every table and use it with the WHERE option (WHERE timestamp >= time of last sync)
peterlaursen
ParticipantCode:How do you save the query you have created with the Query Builder and then, later on, return it to the Query Builder for further editing?Thsi is not supported currently. It is also not top priority. I would say that in a scale from 1 to 5 it is 2 or 3.
peterlaursen
ParticipantPlease attach a sql-dump (and please zip it). If we copy from your post browser encoding issues may fool us.
I propose you create a small table like
Code:CREATE smalltable as select * from realtable where {where-condition satisfined by the data you just pasted};(note this one row is enough)
Next export smalltable (both structure and data) with SQLyog, zip and attach here. If there are some private data you may create a ticket.
We will try to figure this out then. But if it is not a SQLyog issue, this is beyond normal product support though .. but anyway we will give it a try!
peterlaursen
ParticipantWe have two FAQs often reffered to here:
http://webyog.com/faq/content/34/148/en/do…y-language.html
and
http://webyog.com/faq/content/34/152/en/my…-in-sqlyog.html
It really looks like data were stored by an application that does not care about databae/table charset but encodes and decodes client-side. This we cannot support. SQLyog displays what is stored in the database – simply!
However if you can give a good example of a string
1) as it displays now
2) as it should display
.. we may be able to come closer!
This is only a guess, but it could look like changing encoded affected colums in three steps like:
1) from varchar utf8 to varchar latin1
2) from varchar to varbinary/BLOB
3) from varbinary/BLOB to varchar utf8
.. would reencode correctly, but even if this should solve the display issue in SQLyog after that that application using those data will not be able to any more.
peterlaursen
ParticipantI think this http://code.google.com/p/sqlyog/issues/detail?id=732 is the same.
peterlaursen
Participantbefore importing locate the table in the 'Object browser' (the left pane of the program). right-click it and select 'truncate table'.
That will delete all data, but leave the table structure intact.
peterlaursen
ParticipantHow are you importing? CSV? SQL-dump? Migration Tool?
peterlaursen
Participantno .. you can only copy one cell at a time.
But actually you can do this:
Import the Excel spreadsheet into an Access database (option exisits in Access) and transfer to MySQL using the Migration Wizard (requires Enterprise edition – but the TRIAL will work for a month). And alos requires a MS-Office edition that includes Access of course!
peterlaursen
ParticipantI think the problems might this one
http://webyog.com/faq/content/28/73/en/i-h…g-csv-data.html
” And in most of continental Europe (where the comma is used for decimal notation – ie: “4.123,7” instead of English notation “4,123.7”) it is a de facto convention to use semicolon and not comma as field separator! Localized versions of Microsoft Excel and the Microsoft text-ODBC-driver handles it that way for instance! Thus as CSV really becomes a SSV ('Semicolon Separated Value') in most of Europe. But not matter what: SQLyog handles it all.”
Where are you from? What is the language setting of you computer? What language edition is your MS Office?
If the file uses “;” as field seperator you should enter this character as seperator in the SQLyog import dialogue (“fill excel friendly values” option works only directly with English Excel versions.
And of course you should double-check that the table you import to has the correct number and type of columns.
peterlaursen
ParticipantNo!
Could you explain why you want this? I do not understand how to use it in MONyog context. MONyog uses no active code (“no agents”) on the servers running MySQL – except for the MySQL server and the OS themselves of course.
peterlaursen
ParticipantI don't know the 'Wine application menu'. I think it gets differently implemented in different distros? Anyway let us check on Ubuntu!
We will record all issues to our issue tracker of course. But I cannot promise that we will solve with priority! But please continue reporting what you come across!
peterlaursen
ParticipantNo. I cannot think of any way to do this with *any* client actually!
Of course you can use a simple UNION syntax like:
Code:select * from db1.t1 union all select * from db2.t2;Union syntax: http://dev.mysql.com/doc/refman/5.0/en/union.html
That will display all the data, but the resultset is not updateable (also not if you create a VIEW defined like that). The resultset has no information about from what database.table each row in the result came!
Now just like we do with JOINs we could populate the dropdown in the result tab with the tables unioned so that user could select (if he could identify) where to update. We do not support from GUI no matter if tables are in same or different databases (and also we do not support updating from a JOIN statment spanning multiple databases currently .. but that is something we intend to do). We could theoretically too with the simple UNION statement above. But then consider a UNION of two or more statements using JOINs … what a mess!
I think we will never try to support updation of results generated with a UNION'ed statement!
peterlaursen
Participant1) We have no plans of adding SQLyog to KDE and GNOME menus automatically. Did I understand correct? Do you know any other Windows program that does under Wine? I am afraid we would need specific scripts for each and every combination of distribution and version!
2) I am KDE user (on OpenSuSE 11) primarily when using Linux. In KDE you can define a certain file(extension)type to be opened with a specific program. First time you click such file it will prompt you for with what program to open and ther will be an option 'always —'. No such thing in Ubuntu/Gnome when double-clicking on it?
3) I will let testers check 3) tomorrow.
4) Yes – I think multiline querys should be 'normalised', n r and t at the beginning and at the end should be stripped. Was that it? Actually I would also consider replacing those with a single SPACE in the middle of a query!
If replies were inappropriate/misunderstood please explain again!
peterlaursen
ParticipantIssue with HISTORY confirmed. The autoinc. in table structure definition *is* copied however.
(however you should note that FOREIGN KEY CONSTRAINTS are not copied by 'duplicate table'. This is *not a bug* — this is per design!)
peterlaursen
ParticipantWhen regsitering servers you will have to check the option that 'this is a replication slave' for the slave server. If this is not selected MONyog will not collect replication-related information.
Was that the issue?
-
AuthorPosts