Forum Replies Created
-
AuthorPosts
-
RiteshMemberQuote: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?
RiteshMemberCan 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.
RiteshMemberDatabase Synchronization Wizard tool/feature is available from v3.6x upwards. v3.11 is very old and I strongly recommend you to upgrade.
RiteshMemberWhich 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.
RiteshMemberStrange. 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.
RiteshMemberNo. Currently we dont have any site to tell you our progress.
RiteshMemberISP access problem would be resolved in the next 6-8 weeks.
We are working on a PHP/HTTP tunneling interface for SQLyog.
RiteshMemberThis is strange. Can you mail me the SQL file? I will ask my development team to work on it.
RiteshMemberDo 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
RiteshMemberThe following links might help:
RiteshMemberIf the table is not present in the target, SJA will automatically create the table and populate it with data from the source table.
RiteshMemberCan you post a screenshot of the garbage window?
RiteshMemberWe are developing a HTTP/PHP tunneling bridge. You should be able to see the first cut in the next 6-8 weeks!
RiteshMemberOne 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.
RiteshMemberInteresting. 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