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

Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 2,527 total)
1 2 3 … 115 116 117 … 167 168 169
  • Author
    Posts
  • July 2, 2004 at 12:09 pm in reply to: detect changes only for specific columns #16029
    Ritesh
    Member

    My developers are working on it 😀

    July 1, 2004 at 6:36 pm in reply to: SQLYog Max #15942
    Ritesh
    Member

    Waiting for your comments and feature requests.

    July 1, 2004 at 6:34 pm in reply to: mysql fails to execute sqlyog batch script #16044
    Ritesh
    Member

    Can you tell me the complete error message?

    Quote:
    Also, I do not have the option of executing the sql scripts from SQLyog.

    Use Tools -> Execute Batch File…

    July 1, 2004 at 2:57 pm in reply to: detect changes only for specific columns #16027
    Ritesh
    Member
    Shadow wrote on Jun 30 2004, 02:05 PM:
    Wait a second, Ritesh! A quote from the help file:

    Quote:
    Additionally, you can configure SJA to detect changes only for specific columns. This makes it an ideal tool to sync data even if there is limited bandwidth. Since SQLyog uses checksums to detect changes unselecting BLOB data may significantly speed up the process as these columns will not be used to generate checksums.

    In my interpretation sja uses the values of the selected columns to generate checksums not vica versa! Actually, it works for me the above descibed way…

    Mackenzie: there may be other options you didn't set in the right way. Could you post sample data in this forum that don't work for you?

    Ooopps. I was wrong with that statement. SJA will use the selected columns to generate checksums and not the other way round. Sorry 🙄

    July 1, 2004 at 2:22 pm in reply to: Can't Connect to Database #16042
    Ritesh
    Member

    We have to specially compile SQLyog 3.71 for you with the old client library.

    July 1, 2004 at 2:40 am in reply to: SQLyog For Linux #15993
    Ritesh
    Member

    SQLyog Max – the next generation upgrade to SQLyog has been released. Linux binaries of SQLyog Max are available at http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=883

    June 30, 2004 at 12:27 pm in reply to: data sync error on one table #16037
    Ritesh
    Member

    As you can see there is no PRIMARY KEY defined. I can only figure out one index that is named id

    June 30, 2004 at 7:58 am in reply to: data sync error on one table #16035
    Ritesh
    Member

    Please paste the result for the following query:

    Code:
    show keys from `yourdb`.`users2`
    June 30, 2004 at 7:33 am in reply to: detect changes only for specific columns #16022
    Ritesh
    Member

    SJA is behaving correctly. It ignores the selected columns while generating checksums. If the other columns result in different checksums then the whole row is modified in the target db and not the columns that were selected.

    This feature is useful when you dont want to check for changes in BLOB data to reduce the computation time.

    June 28, 2004 at 10:03 am in reply to: SJA may not work properly because of the… #16017
    Ritesh
    Member

    Your configuration will work.

    June 22, 2004 at 4:43 pm in reply to: Batch queries and exporting #15958
    Ritesh
    Member

    Right click on the result window and select Export resultset

    June 22, 2004 at 4:40 pm in reply to: mysql data sync #16004
    Ritesh
    Member

    Data Synchronization Tool is only available from SQLyog v3.6 upwards. SQLyog 3.11 is very old and we have added many new features after this release.

    SQLyog Job Agent (SJA), the data sync tool of SQLyog is perfect for your case. I will suggest that you download SQLyog 3.71 and try-out the data sync tool.

    June 20, 2004 at 6:37 am in reply to: Schema to sync AND notify #15973
    Ritesh
    Member

    As of now you cannot send results of sync over email.

    This is a good suggestion though and I have forwarded it to my development team.

    June 20, 2004 at 6:22 am in reply to: sja Timeout issue #15987
    Ritesh
    Member

    Thats a good suggestion. I have forwarded it to my development team.

    June 19, 2004 at 5:00 pm in reply to: Duplicate Entry Error #15978
    Ritesh
    Member

    I am still not clear about how are you “synchronizing” data…

    Are you using the “Database Sync Tool” of SQLyog to sync data?

  • Author
    Posts
Viewing 15 posts - 1,726 through 1,740 (of 2,527 total)
1 2 3 … 115 116 117 … 167 168 169