Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberIn Windows, SJA is available only with SQLyog.
SQLyog 3.62 contains the most updated version of SJA i.e. 1.1.
Ritesh
MemberA similar problem existed in ver 3.6 and 3.61 but has been resolved in 3.62. Are you sure that you are running 3.62?
Ritesh
MemberBTW, which version of SQLyog are you running and the MySQL versions of your source and target server?
Ritesh
MemberI made some changes in tables “tblweborders” and “tblwebquoteitems” for the target database and ran the sync tool. This is the output given by SJA.
Code:SQLyog Job Agent Version 1.1
Copyright (c) Webyog. All Rights Reserved.Sync started at Tue Nov 18 17:25:06 2003
Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
`tblemaillist` 705 705 0 0 0
`tblorderstatus` 13 13 0 0 0
`tblorderstatushistory` 110 110 0 0 0
`tblsurvey` 58 58 0 0 0
`tblweborderitems` 94 94 0 0 0
`tblweborders` 43 43 0 10 0
`tblwebquoteitems` 25207 25207 0 13 0
`tblwebquotes` 1801 1801 0 0 0
`tblwebupgradeitems` 0 0 0 0 0Total time taken – 4 sec(s)
Can you send me the SQL script of the target database with some modified data?
Ritesh
MemberI have received it.
Will revert back soon.
Ritesh
MemberWe are looking into the matter. Give us some time.
Ritesh
MemberSend them to [email protected]. It will be nice if you can send a script of the table.
Ritesh
MemberThanks for the information 😀
Ritesh
MemberSQLyog exports the “Create Table…” stmts. returned by the MySQL server. It does not modify anything before dumping it into the export file.
Ritesh
MemberIn the Tools->Preference, uncheck “Truncate Columns To Max Data Size…”
Ritesh
MemberQuote:that I have to download the max binary and install for it. Is this correct?correct 😀
A complete documentation on how to start MySQL with InnoDB support can be found at http://www.innodb.com
Ritesh
MemberSQLyog logs all the queries in the History window.
Can you tell me which query is returning the error?
Ritesh
MemberThere is no difference between XP and 2k.
Are you sure you have given the correct permission tothe XP host as you have given to the 2k host?
Ritesh
MemberYou have to configure MySQL for InnoDB. After the server has been configured you can cconvert the table handlers to InnoDB using “Change Table Type To…” option.
A very good tutorial on managing FK using SQLyog can be found at http://www.weberdev.com
Ritesh
MemberSQLyog does not support FK in ODBC Import. This feature is planned for SQLyog Max.
You cannot create relationships on tables with MyISAM table handlers. You have to use InnoDB Table handlers. For more information on InnoDB visit http://www.innodb.com
HTH
-
AuthorPosts