Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberQuote:Well yes. But in case it returns TRUE on one server and FALSE on the other, what then ? In case of OR that would “qualify” the row for comparison on data – in case of AND it would not!If the query with the WHERE clause returns data in the source but not in the TARGET then those rows will be added in the target server. If the query with the WHERE clause does not return data in the source but returns in the TARGET then those rows will be deleted from the target server.
Can you give me an example where you would like to have AND or OR functionality?
MemberQuote:I guess that the WHERE's executed at source and target respectively are logically OR'ed to find records that qualify for the sync ?Nope. It simply executes the same query in both the server.
Quote:think you should provided some more accurate documentation on how it works. Maybe even some user settings regarding the behaviour of the SQL_WHERE would be an idea. But at least a VERY PRECISE documentation should be provided – it is people's DATA at stake!I guess we need to improve our documentation on this subject.
MemberRitesh wrote on Jun 13 2005, 07:22 AM:I guess its a bug with the GUI wizard provided with SQLyog. I have forwarded the issue to my development team.Bug fixed in v4.07 development tree.
MemberBug fixed in v4.07 development tree.
MemberQuote:One last Q: how did you see the Linux-style line-endings – I have a lot of editors, but none of them show it ??Linux style line-endings contains only whose ASCII value is 10. Open your file with any hex editor and your will see the value.
MemberQuote:Why must the escape-sequence be \ when there is nothing to escape here ??You need not. Just uncheck the option Escaped By… in the Escape Character dialog box.
Quote:Why must the fields be enclosed by ” ' ” when they really are only enclosed by ” ' “' denotes a literal in MySQL's SQL. So you have to escape it with a . Clients like SQLyog should actually do it for your but right now this feature is not implemented.
Quote:I also don't understand why the “lines teminated by” must be ” n “.The file which you had sent be had linux line line endings i.e. just n. Thats a good reason of why only n is working.
Quote:Why can't I just use exactly the same vaules in the export-settings dialogue and the import-settings dialogueWhat values did you use to export it? You should be able to use the same settings to correctly export/import data. If you are not then its a bug with SQLyog.
MemberThanks.
I have forwarded your issue to my development team.
MemberA linux version is under development but it will take time before the first BETA is out.
SQLyog is developed using Win32 APIs and uses MySQL C library to access & work with a MySQL server. Our primary development server is Win XP SP2 with our testing machines running Win 95 and Win 2K.
Best of luck in your quest to learn. 😀
MemberI got 17 rows imported correctly.
The data that you just pasted seems to be different from the one that you sent me. It is now enclosed by rather then “
When you click Import, SQLyog will log the correct Load local infile… query in the SQL window. Do you find anything wrong?
MemberWhenever there is a conflict of primary keys between the source and target server, the data from the source will overwrite target.
MemberYou can directly store images in MySQL. You have to use either blob, mediumblob or longblob datatype to store images. SQLyog provides you with a GUI to work with images.
MemberSQLyog is a Windows only application. SQLyog Job Agent (SJA) is available for both Windows and Linux.
For more information on SJA, please visit: http://webyog.com/sqlyog/sja.html and http://www.sitepoint.com/article/mysql-dat…qlyog-job-agent
MemberI guess its a bug with the GUI wizard provided with SQLyog. I have forwarded the issue to my development team.
Memberpeterlaursen wrote on May 30 2005, 10:44 AM:`mp3_filer` 37325 37090 280 770 10But there is some inconsistency:
1)
280+770+10 = 1060. How could more rows be affected than the number that “qualify” with the WHERE-clause ?
Insert/Update/Deleted data consists number from both source and target. Thus it need not be necessarily same as numbers of Source server.
-
AuthorPosts
