Forum Replies Created
-
AuthorPosts
-
RiteshMemberRiteshMember
Can you cut-n-paste the XML schema for the job when you are using SSH tunneling (you can remove the username/password)?
Do you have MSN?
RiteshMemberI have forwarded the issue to my development team.
RiteshMemberWhich version of MySQL are you connecting to?
Depending upon the MySQL version I can ask my development team to release a special build for you.
RiteshMemberI have forwarded the issue to my development team.
RiteshMemberThe error wont effect the Sync tool.
You can very well use Tools->Power Tools->Database Synchronization Tool….
RiteshMemberThe best workaround is to add an auto-increment column in the table.
RiteshMemberRight now you need to have a PRIMARY KEY defined for a table to be synced. That is the only way to determine a unique row of data in a table.
We are working on a work-around where SJA will automatically truncate the data in the target table and do a complete insert from source to target.
RiteshMemberWork on the cross platform version i.e. SQLyog Max is going on. I cant really comment on the release date as of now.
RiteshMemberThis is an issue when you try to sync data between a MySQL 3.23.x server and a 4.x server.
Both the versions return different checksums for the same data when used along with concat_ws(). This results in incorrect working of SJA.
It is recommended to sync data between same versions of MySQL.
RiteshMemberWhich versions of MySQL & SQLyog are you using?
Can you mail me the table sturcture and sample data for Agentsmoney?
RiteshMemberI have forwarded all your suggestions to my development team.
#2 and #3 is actually planned for v4.1. #5 can be done using Table->Reorder Columns…. As of now we dont have any plans to implement #6 before SQLyog Max.
Can you explain #7 a little more? An example will be great.
About #4
Have you tried Edit->Insert Templates…?
RiteshMemberScheduled backup is in the TO-DO list of v4.1.
Scheduled import of batch file is in the TO-DO list of v4.2.
RiteshMemberCan you try the sync process without SSH tunneling?
Are both your source and target server located at remote machines? Is it possible to send some sample data with the table sturctures? It will be very helpful in reproducing the error out here. Also the XML schema that you are using will be helpful.
BTW, check out http://dev.mysql.com/doc/mysql/en/Gone_away.html. It might help you solving the error.
RiteshMemberI have forwarded the issue to my development team.
I will let you know about the progress soon.
-
AuthorPosts