Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 7,398 total)
  • Author
    Posts
  • in reply to: #27332
    peterlaursen
    Participant

    In 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)

    in reply to: #26889
    peterlaursen
    Participant
    Code:
    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.

    in reply to: #27322
    peterlaursen
    Participant

    Please 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!

    in reply to: #27320
    peterlaursen
    Participant

    We 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.

    in reply to: #27318
    peterlaursen
    Participant
    in reply to: #27316
    peterlaursen
    Participant

    before 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.

    in reply to: #27314
    peterlaursen
    Participant

    How are you importing? CSV? SQL-dump? Migration Tool?

    in reply to: #27310
    peterlaursen
    Participant

    no .. 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!

    in reply to: #27311
    peterlaursen
    Participant

    I 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.

    in reply to: #27303
    peterlaursen
    Participant

    No!

    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.

    in reply to: #27299
    peterlaursen
    Participant

    I 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!

    in reply to: #27302
    peterlaursen
    Participant

    No. 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!

    in reply to: #27297
    peterlaursen
    Participant

    1) 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!

    in reply to: #27289
    peterlaursen
    Participant

    Issue 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!)

    in reply to: #27291
    peterlaursen
    Participant

    When 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?

Viewing 15 posts - 2,686 through 2,700 (of 7,398 total)