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

Forum Replies Created

Viewing 15 posts - 586 through 600 (of 642 total)
1 2 3 … 39 40 41 42 43
  • Author
    Posts
  • June 27, 2003 at 10:19 am in reply to: Unique Key for Redundant Servers #14599
    Shadow
    Member

    You could use a GUID generator to create unique keys. A google search of “guid generator” will turn out dozens of such components.

    June 27, 2003 at 6:16 am in reply to: BUG: Unhandled exception during minimize/maximize #14598
    Shadow
    Member

    It took me several attempts, but yes, there is a bug. The same happens if you switch between SQLyog and another application quickly several times.

    June 26, 2003 at 6:54 am in reply to: SQLyog updates all fields in the row #14595
    Shadow
    Member

    I see. Until then we'll be granting users just a bit more rights…

    June 25, 2003 at 8:39 am in reply to: duplicate column name "id" #14571
    Shadow
    Member

    This error should occur when you want to create/alter a table with two columns having the same name. Could you specify the the structure of the table to be copied?

    June 25, 2003 at 6:28 am in reply to: Unable to connect #14253
    Shadow
    Member

    Scripts embedded in web pages work because they are run on the server thus considered as local connection. I know nothing about the control center.

    June 24, 2003 at 7:21 am in reply to: BUG: Syntax Highlighting Repaints Errors in 3.5 #14567
    Shadow
    Member

    Well, no sort of things occur to me at all (Win2K, SQLyog 3.5). Syntax highlighting has always been correct. It's true, however, that CAST and CONVERT functions are not reconized, although CONVERT is the ODBC syntax for CAST. The reason for this, I believe, is that both functions were added in MySql 4.0.

    June 24, 2003 at 7:14 am in reply to: BUG: Trouble Scrolling Down in v3.5 #14545
    Shadow
    Member

    Win2K SP3, MySql 4.1-alpha. Generally I have scrolling problems on Win98, nothing seems to work on that platform the way I got used to on Win2K 😛

    June 24, 2003 at 6:31 am in reply to: Export to CSV #14569
    Shadow
    Member

    First of all, if you have commas in your fields, then “fields terminated by” option should not be “,”, unless you specify “fields enclosed by”. Secondly, before updating your text fields, you should check for special characters such as “, and have them escaped.

    For example,

    Quote:
    Hello ” Kevin, Peter” , how are you?

    should be entered as 'Hello ” Kevin, Peter” , how are you?' . In this case “” is the escape character.

    June 23, 2003 at 2:04 pm in reply to: Scrolling left to right in result window… #14562
    Shadow
    Member
    Quote:
    ResultWindow or Insert/Update Window

    It works fine for me…

    June 23, 2003 at 9:41 am in reply to: CSV import #14558
    Shadow
    Member

    Perhaps the end-of-line character (/n) is not reconized properly. Convert the CSV file, then retry importing.

    June 23, 2003 at 7:34 am in reply to: BUG: Trouble Scrolling Down in v3.5 #14543
    Shadow
    Member

    Scrolling works for me as well, but the last line is accessible via arrow keys as msha noted.

    June 20, 2003 at 6:56 am in reply to: what is mySQL host address? #14538
    Shadow
    Member

    Besides, it would be quite unusual to have MySql running on the FTP server…

    June 20, 2003 at 6:44 am in reply to: Unexpected Behavior: Column Number in Status Bar #14536
    Shadow
    Member

    Well, I'm the luckier one! 😀

    June 20, 2003 at 6:33 am in reply to: large query settings #14553
    Shadow
    Member

    The table type may also affect which settings should be altered, but the following ones have the most influence on performance:

    set-variable = read_buffer_size

    set-variable = key_buffer_size

    set-variable = max_allowed_packet

    set-variable = table_cache

    set-variable = sort_buffer

    set-variable = net_buffer_length

    set-variable = myisam_sort_buffer_size

    4.5.6.4 SHOW VARIABLES section of MySql manual explains these settings in detail, but generally assigning higher values to these variables will increase the speed. But in case of such large tables, I would recommend to get additional memory (at least 512MB plus).

    June 19, 2003 at 2:27 pm in reply to: Unexpected Behavior: Column Number in Status Bar #14534
    Shadow
    Member

    SQLyog v3.5 corrects this behaviour.

  • Author
    Posts
Viewing 15 posts - 586 through 600 (of 642 total)
1 2 3 … 39 40 41 42 43