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

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 158 total)
  • Author
    Posts
  • in reply to: Database Synchronization Exception #35656
    Sibin A S
    Moderator

    Hi,

     

    SQLyog performs the sync between all the columns between the tables. There is no option to exclude a specific column from being synced.

     

    In SQLyog, there is an option to select specific columns to be compared to determine the updates to be done in the target. But, it does not mean that only the selected columns are synchronised. Irrespective of the columns selected to perform the checksum calculation, SQLyog would sync all the columns in a table. 

     

    For more information, please refer the doc >> http://sqlyogkb.webyog.com/article/294-selecting-tables

     

    Regards,

    Sibin

    in reply to: Inconsistent Version Numbering Scheme #35627
    Sibin A S
    Moderator

    Hello larsen,

     

    We have fixed this issue with the latest release. Please find the release note here >> http://blog.webyog.com/2016/02/12/sqlyog-mysql-gui-12-2-0-released/

    in reply to: Sqlyog 12.19 Very Slow #35660
    Sibin A S
    Moderator

    Hello Mitch,

     

    We have identified the issue. We plan to release the new build with the fix in 30-45 minutes. Thanks for your patience in advance.

     

    Regards,

    Sibin

    in reply to: Editor Stop On Error? #35617
    Sibin A S
    Moderator

    Hello Scott,

     

    We have added your request into our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2097. 

     

    We have replied in the ticket created by you.

     

    Regards,

    Sibin 

    in reply to: Better Filter Feature For Data Tab #35484
    Sibin A S
    Moderator
    Hello rguillemette,

     

    We are not sure how this post was missed, please find the solution to your queries,

     

          1. The “Filter” icon in the Result window refreshes the existing filter and provides an option to create new filter.

     

    In your case, once a filter is created, you can use the existing filter to add/modify it by  selecting the corresponding cell in the table data and right click on it and select the “Custom Filter” option from the option-list (“Filter -> Custom Filter”) to retain/use the filter. Please refer the below screenshot for the same

     

    S3aV4b8.png

     

     

     

          2. Filter is table specific. Same filter cannot be applied to different tables, Consider the case when the same filter is applied on another table that do not have any common columns, this would result in an error.

     

    Regards,

    Sibin

    in reply to: Crash Genering Update Sql #35637
    Sibin A S
    Moderator

    Hello Mitch,

     

    So what exactly do you mean by writing “Repeatable crash”. Did the program simply disappear for instance? In case of a crash, there would be a crash dump file that would get generated. 

     

    Can you tell us in detail the steps that lead to the crash as we aren’t successful in reproducing it at our end.

     

    Also tell us the environment where SQLyog is installed and also the SQLyog version.

    in reply to: Editor Stop On Error? #35615
    Sibin A S
    Moderator

    Hello Joviel,

     

    You can use the “SQL Scheduler and Reporting Wizard” from the “Powertools” menu which provides the option to “Exit immediately” or “Continue with next query” when an error occurs while executing scripts. 

     

    You can also schedule the execution to run immediately or later. Please refer  the doc >> http://sqlyogkb.webyog.com/article/306-choosing-what-to-do

     

    SQLyog lets you either ‘Send the query results to an email’ or ‘Execute scripts and also send an email on error’ with this option.

     

    Regards,

    Sibin

    in reply to: Feature Request: Right Click On View To Copy #35622
    Sibin A S
    Moderator

    Hello Mitch,

     

    When Stored Procedures, Views, Functions and Triggers are copied to different host, MySQL also returns their definition with the database name in it. Stripping out the database name and executing them seems to be difficult and very time-consuming to code to remove the database name correctly and execute it in different context automatically. 

     

    in reply to: Feature Request: Play Sound When Query Completes #35614
    Sibin A S
    Moderator

    Hello Mitch,

     

    We have added your feature request into our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/1022

     

    Regards,

    Sibin

    in reply to: Crash Genering Update Sql #35600
    Sibin A S
    Moderator

    Hello Mitch,

     

    We are able to reproduce the crash at our end. We will check the issue and debug the issue shortly.

     

    Regards,

    Sibin

    in reply to: Incorrect Sql When Updating Table In Join #35587
    Sibin A S
    Moderator

    Hello Mitch,

     

    The data in the resultset is obtained after executing the query and not from the table.

     

    In the resultset (join of two tables), UPDATE query is fired when you try to modify the value of an existing row. INSERT query is fired in case of a new row is added.

     

    Regards,

    Sibin

    in reply to: Problem Typing In Field With Foreign Key #35593
    Sibin A S
    Moderator

    Hello Mitch,

     

    We are not able to reproduce this case at our end  with wine version 1.6.2 and all the characters(especially the first character) do show up in the field.

     

    Regards,

    Sibin

    in reply to: Sync Or Sql Dump With Where #35605
    Sibin A S
    Moderator
    Hello Davemarks,

     

    You can use the ‘Visual Data Compare‘ tool to sync only the data that aren’t similar in the source and destination tables by selecting the option ‘Hide similar rows’ in the ‘Visual Data Compare’ wizard. This option presents only the data that has to be synced between the servers excluding the similar data.

     

    Currently SQLyog supports backing up the databases/tables as a whole. The reason SQLyog doesn’t perform backing up only the newly added rows is that SQLyog being a MySQL Client cannot fire queries to the dump file to fetch the data that is already present in it and perform the backup of remaining data.

     

    Regards,

    Sibin
    in reply to: Generating Charts Directly In Sqlyog #35582
    Sibin A S
    Moderator

    Hello Stephan,

     

    From your feedback “To allow an initial analysis of the data we are looking for a way the result of a question directly display in SQLYog as a diagram“, If I understand your question correctly, do you mean to display the charts based on the result of an executed query. If so, SQLyog has no option to display them.

     

    Regards,

    Sibin

    in reply to: Feature Requests: File Explorer #35562
    Sibin A S
    Moderator
    Hello christophe,

     

    Thanks for your valuable feedback. We will consider your views that will help us make SQLyog better. We have added your request into our issue tracker >> https://github.com/webyog/sqlyog-community/issues/1180.

     

    A work around is, you can save a session restore point manually and always open the files that you may require to pen every time.

     

    Regards,

    Sibin

Viewing 15 posts - 136 through 150 (of 158 total)