[Ritesh]

peterlaursen wrote on Jun 1 2005, 01:22 PM:

Does the SQL_WHERE option in the job-file have effect

1)for INSERTS+UPDATES

or

2)for UPDATES only

Both.

[Ritesh]

peterlaursen wrote on May 30 2005, 09:03 AM:

I came across one thing more:

1) On the target run this: UPDATE SET mychar = 'newstring' WHERE mychar = 'oldstring';

2) Run SJA with the clause WHERE ” mychar = 'newstring' “

3) The row UPDATED first with 1) are now deleted on the target. I don't see the logic!!! Since no rows in the source fullfill the WHERE (in source value is still 'oldstring') nothing should happen I think!

Its correct. The same where clause fulfills the criteria in the target but they are not existing in the source. Thus those rows are deleted in the target server as expected.

[Ritesh]

Quote:

I now assume that the WHERE-clause is tested with the source!? Correct ?? Always?? For both 1-way and 2-way sync ??

Nope. The WHERE clause is checked for both source and target. SJA always executes the same query to both source and target.

[Ritesh]

@duffbeer: I am still waiting for the Create Table… stmt.

[Ritesh]

@Peter:

I was able to correctly import data using the following escape characters.

Note: You have to use ' and not '.

[Ritesh]

By Create Table…, I mean the DDL statement that is used to create a table. I am attaching an image to depict my requirement.

[Ritesh]

Bug fixed in v4.07 development tree.

[Ritesh]

Shadow wrote on Jun 3 2005, 12:44 PM:

Issue a SHOW WARNINGS command from SQL window.

Starting from v4.07, a SHOW WARNINGS button will be provided to easily view the warnings. This feature has already been implemented in the SQLyog v4.07 development tree.

[Ritesh]

@peterlaursen: Can you mail me the actual .CSV file or a SQL dump of the table?

[Ritesh]

@duffbeer: What are the Create Table… stmts. of nuke_topics and cms_topics?

[Ritesh]

Very strange.

Can you mail me the CSV file? It will be very helpful if you can post screenshots of your CSV Import and Escape Characters window.

[Ritesh]

I have forwarded the issue to my development team.

[Ritesh]

One license permits you to install and execute SQLyog on one machine. You can connect to unlimited number of MySQL server using one license.

You will need to purchase multiple licenses if you plan to install it on more than one machine.

[Ritesh]

We have plans to support additional languages from v4.2.

[Ritesh]

@Mic: By any chance are you using sja in php as a different user?

[Author]

Posts