Forum Replies Created
-
AuthorPosts
-
RiteshMember
Can we chat on MSN or Yahoo?
RiteshMemberI 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.
RiteshMemberQuote: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
RiteshMemberPlease 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?
RiteshMemberDownload the latest version i.e. SQLyog v4.03 from SQLyog Download Page. v4.03 supports server level encoding.
RiteshMemberYou have a mail.
RiteshMemberI 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.
RiteshMemberAs 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.
RiteshMemberRiteshMemberGreat to know that SQLyog works for you 😀
RiteshMemberYes 😀
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' );RiteshMemberDo you mean setting up a MySQL server in Linux and using SQLyog to work with it?
RiteshMemberSJA, 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?
RiteshMemberCurrently, SJA for Linux does not support tunneling. You have to use Windows version of SJA if you want to use tunneling.
RiteshMemberI talked to Mike over MSN and he was forgetting to provide the password.
-
AuthorPosts