Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 391 through 405 (of 642 total)
1 2 3 … 26 27 28 … 41 42 43
  • Author
    Posts
  • January 23, 2004 at 12:48 pm in reply to: Bug in Index / Update Table #15402
    Shadow
    Member

    Hmmm, 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…

    January 17, 2004 at 10:52 pm in reply to: OMG – This program is incredible #15395
    Shadow
    Member

    Sorry, I was wrong! Do not quote elmonty's opinion! 😀

    January 17, 2004 at 10:50 pm in reply to: Error No 1043 – Bad handshake #15324
    Shadow
    Member

    Have you tried increasing the different timeout settings?

    January 11, 2004 at 10:09 pm in reply to: OMG – This program is incredible #15392
    Shadow
    Member

    Hey, Ritesh, you MUST quote the previous post on the main page of webyog.com!

    January 11, 2004 at 10:03 pm in reply to: Syncing Tables without a Primary Key #15388
    Shadow
    Member

    SQLyog 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!

    January 11, 2004 at 9:55 pm in reply to: MySQL Host Address #15382
    Shadow
    Member

    If 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.

    January 11, 2004 at 9:51 pm in reply to: Bug in Job Agent? #15383
    Shadow
    Member

    SQLyog 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…

    January 3, 2004 at 12:46 pm in reply to: "Read Only" Tables #15377
    Shadow
    Member

    Even 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.

    January 3, 2004 at 12:37 pm in reply to: Syncronization with DB2? #15373
    Shadow
    Member

    Have you checked MySql's home page for such tool?

    December 23, 2003 at 8:04 am in reply to: Import from Access stalling #15370
    Shadow
    Member

    I 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.

    December 22, 2003 at 1:50 pm in reply to: Important Features MISSING! #15355
    Shadow
    Member

    I 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.

    December 22, 2003 at 1:42 pm in reply to: Import from Access stalling #15368
    Shadow
    Member

    max_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!

    December 22, 2003 at 12:36 pm in reply to: Import from Access stalling #15366
    Shadow
    Member

    Either 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.

    December 22, 2003 at 11:18 am in reply to: Import from Access stalling #15364
    Shadow
    Member

    What error do you get?

    December 18, 2003 at 1:27 pm in reply to: Saving grid as csv file email attachment #15361
    Shadow
    Member

    Definitely 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.

  • Author
    Posts
Viewing 15 posts - 391 through 405 (of 642 total)
1 2 3 … 26 27 28 … 41 42 43