Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberCan we chat on MSN or Yahoo?
Ritesh
MemberI received your SQL file. The table structure looks like:
CREATE TABLE `virtual` (
col1,
col2, col3,
UNIQUE KEY `col` (`col1`)
}
If you notice then the key is UNIQUE but not PRIMARY. You have to explicitly define PRIMARY KEY for the table. SQLyog does not support UNIQUE KEY as of now.
Ritesh
MemberQuote:i can send a dump of one of the tables which does infact have a primary key (in which sja reports that it does not)Send to ritesh AT webyog DOT com
Ritesh
MemberPlease provide complete description of your setup. Versions of MySQL, SQLyog and whether you are using tunneling.
Can you send me a backup of your db?
Ritesh
MemberDownload the latest version i.e. SQLyog v4.03 from SQLyog Download Page. v4.03 supports server level encoding.
Ritesh
MemberYou have a mail.
Ritesh
MemberI know we have been little late on this issue but currently we are extremely busy with v4.1 so this fix might take some time.
Ritesh
MemberAs mentioned earlier, SQLyog just sends a bunch of SQL statements to the MySQL server.
You need to help us in pin-pointing the exact SQL that is causing this corruption so that we can get MySQL AB Support involved.
To help us reproduce the error at our end, you need to send some sample data OR do it yourself by logging the queries.
Ritesh
MemberRitesh
MemberGreat to know that SQLyog works for you 😀
Ritesh
MemberYes 😀
You have to use the correct function in PHP or ASP to execute sja with the job file as parameter.
E.g. In PHP you can do:
Code:system ( 'sja.exe schema.xml' );Ritesh
MemberDo you mean setting up a MySQL server in Linux and using SQLyog to work with it?
Ritesh
MemberSJA, the data synchronization tool of SQLyog executes only valid SQL statements to find differences and bring the two databases in sync with each other.
Are you sure that its the query(s) that SJA executes corrupting the data?
Ritesh
MemberCurrently, SJA for Linux does not support tunneling. You have to use Windows version of SJA if you want to use tunneling.
Ritesh
MemberI talked to Mike over MSN and he was forgetting to provide the password.
-
AuthorPosts