Forum Replies Created
-
AuthorPosts
-
RiteshMember
Very strange. I just worked on your issue and everything works as expected. I am running 4.1.7 on both source and target server. I created two tables as told by you. The two table data after inserting were:
and
There wont be one extra 1 as given in the insert into statement as 1 is an escape character.
I did a sync as you said and it worked correctly.
Then I changed the data as:
Ran the sync again and everything was fine.
RiteshMemberQuote:It's is more than 2 times as fast to do INSERT as UPDATEThere is valid reason to that. Its how MySQL (for any database) are designed. Reading the MySQL docs wil throw more light on the subject.
RiteshMemberIt also depends upon your table structure and data. If there are too many blob columns then it takes time to generate checksums for the row.
RiteshMemberI have forwarded the issue to my build team. I think we need to change our NSIS (installer) script 😀
RiteshMemberThe answer is:
Quote:SJA will MAYBE write this change to b-base depending on circumstancesIt will update changes for rows that have still not been considered for the sync.
To get sure-shot result you have to run the sync again.
RiteshMemberCurrently there are no plans to have a FreeBSD version of SJA.
By installing SJA for Windows or Linux, you can very well connect to a MySQL server running on FreeBSD and do the sync.
RiteshMemberCheck out my local port solution provided at: http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1428.
Looks like a MySQL daemon is running on the same port in your local machine as one of the local port.
RiteshMemberQuote:there is a good chance that the source will change during the sync procesI am not sure if I understood the problem. Can you explain a bit more?
RiteshMemberQuote:Once more (I guess it's the 4th time) I shall propose that if it's possible, then it should be possible to use any unique index (and not only a PK) for sync.This option is in the TO-DO list but I am not sure when we will implement it as its pretty low in the priority list.
RiteshMemberWhat is your source and target MySQL versions?
Can you send me sample data and table structure to reproduce the error?
RiteshMemberUnder HTTP Tunneling in the Tunnel tab, there is a button called Advanced. Clicking on it will open up a window where you can specify the Proxy settings.
Are you sure the details provided are correct in it?
RiteshMemberThanks for the report. I have forwarded the issue to my development team.
RiteshMemberI have forwarded the issue to my development team and I will revert back with the bug status soon.
RiteshMemberIts already in our TO-DO list 😀
RiteshMemberpeterlaursen wrote on May 21 2005, 12:55 AM:Selecting “view data” form a table displays the first 1000 rows (“limit 0,1000”). Checking the checkbox “Show All” displays all rows. So far so good. But an attempt to UNCHECK the checkbox makes the program hang – or rather it does not really hang but starts working like mad (>90% CPU-resources) but nothing happens. You will have to close the program,This is a known performance issue with SQLyog and we plan to fix it in v4.1.
-
AuthorPosts