Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberQuote:I can connect fine using my_sql_connect() using the same parameters.I think you are calling my_sql_connect() from a PHP/PERL page that is residing on the same server as your MySQL database?
Ritesh
MemberCan you send me a dump of your database?
Quote:I dont even see the ODBC import feature in SQLYog 4Our latest version is SQLyog 3.71.
Ritesh
MemberDatabase Synchronization Wizard tool/feature is available from v3.6x upwards. v3.11 is very old and I strongly recommend you to upgrade.
Ritesh
MemberWhich version of SJA are you using?
SJA bundled with 3.7x returns non-zero value on success and zero on failure. Many of our customers use SJA under the same conditions like yours and are getting correct return values.
Ritesh
MemberStrange. Both the servers are same and it should not cause any problem.
What is the output of SJA? SJA outputs information about the number of row(s) updated, inserted and deleted during the sync process.
Ritesh
MemberNo. Currently we dont have any site to tell you our progress.
Ritesh
MemberISP access problem would be resolved in the next 6-8 weeks.
We are working on a PHP/HTTP tunneling interface for SQLyog.
Ritesh
MemberThis is strange. Can you mail me the SQL file? I will ask my development team to work on it.
Ritesh
MemberDo you have access to other distributions of Linux? Can you try SQLyog Max on those boxes?
When does it crash? Can you tell us the specific screen
Ritesh
MemberThe following links might help:
Ritesh
MemberIf the table is not present in the target, SJA will automatically create the table and populate it with data from the source table.
Ritesh
MemberCan you post a screenshot of the garbage window?
Ritesh
MemberWe are developing a HTTP/PHP tunneling bridge. You should be able to see the first cut in the next 6-8 weeks!
Ritesh
MemberOne workaround could be to determine the “source” and “target” using a separate query, generate the SJA XML file dynamically to swap the “source” and “target” (if required) and then run SJA.
However, this wont give you a row level swapping option.
Ritesh
MemberInteresting. It works great for me. I recreated the source and target db on my 4.1.1-alpha-max-nt server. I used the following two schemas:
Code:
localhost
root 3306 source
localhost
root 3306 target
`tablename1`
`column1`
and
Code:
localhost
root 3306 source
localhost
root 3306 target
`tablename1`
`id`
both the cases I got the same result:
Code:SQLyog Job Agent Version 2.0
Copyright (c) Webyog. All Rights Reserved.Sync started at Fri Jul 02 19:38:18 2004
Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
`tablename1` 1 1 0 0 0Total time taken – 0 sec(s)
-
AuthorPosts