Forum Replies Created
-
AuthorPosts
-
RiteshMember
Ok.
We have fixed number of bugs regarding SJA in SQLyog 4.0.
Download the latest BETA from http://www.webyog.com/sqlyog/SQLyog40.exe and install it. Run the sync tool and check if the problem persists.
If the problem still exists, then you have to send me backup of your source database and target database. You can generate the .sql files for these databases through DB->Export Database As Batch Script option.
More information about SQLyog 4.0 can be found at:
RiteshMemberCan you paste the XML schema?
RiteshMemberWhich version of SQLyog are you using?
Can you send us a sample of your data so that we can test it out here and fix the bugs (if there are any)?
RiteshMemberBehaviour confirmed on 3.23.54.
I will revert back soon with the reason(s).
RiteshMemberWhich version of MySQL are you using?
In our MySQL server which is 4.1.1-alpha-max-nt, the following SQLs:
Code:create database testdb;use testdb;
CREATE TABLE `test` (
`example_col` varchar(100) default NULL
) TYPE=MyISAM;create table `test_copy` () type=MyISAM select `example_col` from `test` where 1 = 0;
correctly results in `test_copy` being created and `example_col` datatype is varchar(100).
RiteshMemberSorry for the inconvenience caused but our web-server went down for some time 🙁
RiteshMemberCan you send me your table structure and sample data?
Information about SQLyog and MySQL versions will be helpful.
RiteshMemberWhich version of MySQL?
From your reply it looks like that copying tables *without data* does not result in any error?
RiteshMemberSJA 4.0 bundled with SQLyog 4.0 BETA can use HTTP Tunneling.
You can sync data to your ISPs server even if direct access is not provided 🙂
RiteshMemberSJA only syncs data. For structure synchronization, you have to use SQLyog's -> Structure Sync Tool.
SJA will fail if the table structure in both the servers are not same.
RiteshMemberWe are working on your issue and will revert back soon.
RiteshMemberDo you mean *from date* in the email?
RiteshMemberAre you copying the database to another host or to same one?
Which connection type are you using? Can you send us some sample data?
RiteshMemberSQLyog logs all query(s) that it executes in the History Tab.
Can you see '127' being inserted twice?
RiteshMemberWe are unable to duplicate the problem at our end.
Can you provide us temporary access to your web server?
This would help us resolve the problem quickly.
If that is possible, mail the details to [email protected]
-
AuthorPosts