Forum Replies Created
-
AuthorPosts
-
RiteshMember
As Peter suggested, you can install SJA on a Windows machine and sync two MySQL servers running on any OS.
RiteshMemberWe dont plan to implement concat_ws() on the client side. It will destroy the whole efficiency of the algorithm used in the data sync tool.
You will need to upgrade or downgrade your target server.
RiteshMemberSelect the table in the Object Browser, choose Table -> Paste SQL Statements -> Select col1, col2
It does exactly what you want.
We will be providing a shortcut for the same in the next BETA.
RiteshMemberFixed in BETA 6.
It will now show a status message that query(s) are being executed when SQLyog is executing query(s).
RiteshMemberEnterprise Edition is USD 99 for commercial and USD 49 for non-commercial editions. It has been the same for quite sometime now.
Did you miss something?
RiteshMemberWill be fixed in BETA 6.
RiteshMemberEven I was able to reproduce a similar problem at my end.
Will work on it tomorrow. Maybe requires some changes in the tunnel module.
RiteshMemberHmmm. Nice.
I have added it in the TO-DO list. Will be implemented in v4.2 BETA 6.
RiteshMemberThis is a SQLyog's internal error.
It occurs when SQLyog is not able to correctly parse the XML sent by SQLyogTunnel.php. Generally, it happens when the webserver sends incomplete XML data.
With v4.2 BETA 6, I will add an improved logging mechanism where it will log the received XML in sqlyog.err. This is will give us a better insight on the error.
BTW, before showing the error, SQLyog would have shown the HTTP response in a dialog box. Can you cut-n-paste it out here?
RiteshMemberI have added it in the TO-DO list. We will implement it in one of the future versions of SQLyog.
RiteshMemberBug fixed in 4.2 BETA 6 development tree.
RiteshMemberQuote:I did take an mysql backup before I started messing about.Its always good to have backups of your data 😀
RiteshMemberpeterlaursen wrote on Oct 6 2005, 03:24 PM:thinking about this problems with “orphaned” entries in the MySQL database.I think it would take another option here (see picture) to choose “delete from target when row is not in source”.
Will probably take a lot of coding to implement. 🙁
[post=”7474″]<{POST_SNAPBACK}>[/post]I have added this in the TO-DO list. Maybe we will implement in v4.3. This is more of a 2-way sync issue!
The only issue that I can think of – how a SELECT-WHERE clause with BINARY data works in ODBC? This wont be a problem if a PRIMARY key is defined on the table but then my experience says that many people do have tables without PRIMARY KEYS!
Actually, thinking more on the above issue, it will be a problem if somebody has a PRIMARY KEY on binary data column?
RiteshMemberI have added it in the TO-DO list of SQLyog. We will implement it in one of later BETAS of v4.2.
RiteshMemberCurrently, the mail will be sent in all cases. There is no way to conditionally send a mail. There is no workaround for this at present.
-
AuthorPosts