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

Forum Replies Created

Viewing 15 posts - 106 through 120 (of 642 total)
  • Author
    Posts
  • in reply to: Multiple tables selection #16623
    Shadow
    Member

    I belive it is safer to require the user to manually drop a table, so less accidents happen! But, it's up to Ritesh to decide!

    in reply to: error 1034 bad handshake #16622
    Shadow
    Member

    What is the exact error message?

    in reply to: how to show row# in the result window #16615
    Shadow
    Member

    I don't quite get what you mean because you can get the rows highlighted in the result pane unless you turned the “Show results as text” option.

    in reply to: how to show row# in the result window #16613
    Shadow
    Member

    What do you mean by “row#”? A record's position in the resultset?

    in reply to: Problem with CSV import #16603
    Shadow
    Member

    Well, I would change the contents of that CSV file to resemble YYYY-DD-MM setting. “Although MySQL tries to interpret values in several formats, dates always must be given in year-month-day order (for example, '98-09-04'), rather than in the month-day-year or day-month-year orders commonly used elsewhere (for example, '09-04-98', '04-09-98').” (Manual)

    In my v4.1.7, there is a date_format variable, though. Perhaps you could try to play around with it and see if that helps!

    in reply to: How do I do the following? #16610
    Shadow
    Member

    Provided that your relational db is MySql, then yes, SQLyog is capable of doing that.

    in reply to: VB and SQLyog #16607
    Shadow
    Member

    There is no SQLyog database. SQLyog is a front-end for MySql databases. There are two ways for connecting to a MySql db from VB. The hard way is to export the header of each function in libmysql.dll and write your own client software. The easy way is to download MySql's ODBC driver (MyODBC) from dev.mysql.com and use ADO to connect to MySql. A connectionstring example: “Driver=MySQL ODBC 3.51 Driver;DATABASE=my_db;SERVER=localhost;UID=my_user;PASSWORD=my_password;PORT=330

    ;OPTION=3″. Always set the “do not optimize column width” option at the ODBC settings!

    in reply to: can't log onto a server #16574
    Shadow
    Member
    Quote:
    ERROR 2003: Can't connect to MySQL server on 'myhostaddress' (10061)

    This error message indicates that you knock on the wrong server because MySql client cannot find any working instance of MySql server operating on the given machine.

    in reply to: db lock #16570
    Shadow
    Member

    Tools -> User Manager is what you need. At least, I think so, since your post does not make too much sense to me…

    in reply to: Default options for SQLyog "export as script" #16544
    Shadow
    Member

    It's the max_allowed_packet variable that controls the max allowed length of an insert statement. It could be a major enhancement, if SQLyog recognized this variable while loading data from script files.

    in reply to: Getting Error on Connect MySQL Host #16519
    Shadow
    Member
    Quote:
    I think they have not even updated winmysqladmin for a long time.

    Very true, it's replaced by MySqlAdminsitrator.

    in reply to: SQLyog – how does one schedule a backup? #16525
    Shadow
    Member

    Well, I'm not happy to say, but download MySqlAdministrator from MySql's website and use its scheduled backup. That's what I do currently…

    in reply to: SQLyog creates batch scripts with double-quotes #16530
    Shadow
    Member

    Apparently MySql interprets “time” as a keyword, thus the CREATE TABLE fails.

    in reply to: Getting Error on Connect MySQL Host #16517
    Shadow
    Member

    You must be using the old password scheme then. I don't know if MySql 5.x still has that option… The latest MyODBC is not even 4.0 compliant yet!

    in reply to: Getting Error on Connect MySQL Host #16515
    Shadow
    Member

    You cannot connect to any MySql 4.1.x and 5.x via ODBC with a user that has an assigned password. Create a user with no password and you'll be able to connect swiftly.

Viewing 15 posts - 106 through 120 (of 642 total)