Forum Replies Created
-
AuthorPosts
-
Shadow
MemberHmmm, I tested it with SQLyog 3.61 and 3.63, “Truncate column…” set and unset on W2K SP4 and found no problems. Perhaps, the data length is the cause of the problem…
Shadow
MemberSorry, I was wrong! Do not quote elmonty's opinion! 😀
Shadow
MemberHave you tried increasing the different timeout settings?
Shadow
MemberHey, Ritesh, you MUST quote the previous post on the main page of webyog.com!
Shadow
MemberSQLyog has always been picky on PKs. It won't let you edit a table via its GUI if the table does not have a PK defined.
In the sync case, however, I perfectly understand why SQLyog does not sync tables without PK: it would need to compare the whole content of the desired table to determine which rows differ and that would put heavy load on the machine(s) with the dbs and SQLyog. If you do can create those PKs then go ahead and creat them!
Shadow
MemberIf you have a hosted MySql db (an ISP provides it to you), then you should ask your provider how to connect to your db. Otherwise, the host address is the IP address or the name of the computer where you have the MySql db running.
Shadow
MemberSQLyog is apparently issuing a SELECT statement with a GROUP BY clause that refers to 'hashkey' column and for some reason, MySQL con't do a GROUP BY. It's quite difficult to tell why not knowing the SQL statement…
Shadow
MemberEven if you open a table you may not be able to edit it provided that the given table has no primary key. Constructing corresponding SQL statements manually will do the job, though.
Shadow
MemberHave you checked MySql's home page for such tool?
Shadow
MemberI would increase the wait_timeout setting! My default value is 28800… About max_allowed_packet: find the largest row in your Access db (the row that contains the most data), determine its size in bytes and compare this value to the max_allowed_packet. If the size of the row exceeds max_allowed_packet, then increase the setting's value. Otherwise you can leave it as is.
Shadow
MemberI thought you missed the 'Select for update' feature, that's why I was talkink about SQL statements…
Anyway, you can connect to the same db multiple times and before applying any chages from one connection, swith to the other and check for differences.
Shadow
Membermax_allowed_packet is all right unless you strore huge blobs in the Access db, but I was not talking about connect_timeout, but about wait_timeout. wait_timeout being 5 secs would be a way too short period!
Shadow
MemberEither the communication to your remote db is not ok, or the rows (better to say specific rows) contain too much data. Try increasing the wait_timeout or max_allowed_packet setting of the remote db.
Shadow
MemberWhat error do you get?
Shadow
MemberDefinitely not. SQLyog does not provide any scripting abilities, or any programmable API. It is a MySql admin tool, the only task it is capable of automating is the synchronization of databases.
-
AuthorPosts