Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberRitesh
MemberCan 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?
Ritesh
MemberI have forwarded the issue to my development team.
Ritesh
MemberWhich 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.
Ritesh
MemberI have forwarded the issue to my development team.
Ritesh
MemberThe error wont effect the Sync tool.
You can very well use Tools->Power Tools->Database Synchronization Tool….
Ritesh
MemberThe best workaround is to add an auto-increment column in the table.
Ritesh
MemberRight 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.
Ritesh
MemberWork on the cross platform version i.e. SQLyog Max is going on. I cant really comment on the release date as of now.
Ritesh
MemberThis 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.
Ritesh
MemberWhich versions of MySQL & SQLyog are you using?
Can you mail me the table sturcture and sample data for Agentsmoney?
Ritesh
MemberI 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…?
Ritesh
MemberScheduled backup is in the TO-DO list of v4.1.
Scheduled import of batch file is in the TO-DO list of v4.2.
Ritesh
MemberCan 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.
Ritesh
MemberI have forwarded the issue to my development team.
I will let you know about the progress soon.
-
AuthorPosts