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

Forum Replies Created

Viewing 15 posts - 286 through 300 (of 642 total)
1 2 3 … 19 20 21 … 41 42 43
  • Author
    Posts
  • May 27, 2004 at 8:26 pm in reply to: Error No. 1227? #15886
    Shadow
    Member

    Linda, I would suggest trying out the options yourself. As you are exporting data, no harm can be done to your db!

    May 24, 2004 at 8:02 pm in reply to: Remote Database update #15852
    Shadow
    Member

    There are separate tools for doing data migration between MySql and other dbs but most of them are commercial. You should check out mysql.com for 3rd party migration tools and hope for the best.

    As an alternative, you could write your own little app using ODBC to do the job.

    May 24, 2004 at 7:56 pm in reply to: Minimized window at startup problem #15805
    Shadow
    Member

    But androidtech said he had already ugraded to v3.7 and the problem persisted!

    androidtech: Do any negative values get stored in sqlyog.ini about window position?

    May 24, 2004 at 7:46 pm in reply to: What is error no. 2003 #15823
    Shadow
    Member

    This error message had been dealt with before on this forum. Do a little search at first!

    Btw, are you behind a firewall?

    May 24, 2004 at 7:42 pm in reply to: Error No. 1227? #15883
    Shadow
    Member

    mysqlhotcopy script can also be used for backups. It works from a remote machine as well.

    May 24, 2004 at 7:37 pm in reply to: Mysql/PHP #15741
    Shadow
    Member

    Well, it means that the machine you are attmpting to connect from is not allowed to do so. It is either locked out in the hosts table, or the user in whose name you attempt to connect has a machine name specified – the latter is more likely. You need to set up an account in the form of my_username@my_machine where my_machine is either the complete name of your computer or its IP address (given it is fixed…) or just use '%' instead of my_machine thus allowing my_username to connect from any hosts.

    May 19, 2004 at 6:24 pm in reply to: Good SQL discussion forum? #15808
    Shadow
    Member

    http://www.webyog.com/forums 😀

    May 19, 2004 at 6:23 pm in reply to: Minimized window at startup problem #15803
    Shadow
    Member

    Negative value for window position in the ini file causes this problem.

    May 19, 2004 at 6:05 pm in reply to: No PRIMARY KEY defined #15674
    Shadow
    Member

    Sure, it doesn't matter how many fields a PK has.

    May 3, 2004 at 10:16 pm in reply to: Absolutely WONDERFUL!! #15747
    Shadow
    Member

    I was told that SQLyog will have such capabilities. In the distant future… Till then, use DBDesigner as mentioned.

    May 3, 2004 at 10:14 pm in reply to: Insert/Update is read only #15745
    Shadow
    Member

    You may issue the INSERT/UPDATE statements in the SQL window. SQLyog is capable of generating a backbone for these statements. The GUI – correctly – does not support this feature.

    May 3, 2004 at 10:10 pm in reply to: How do I view warnings on a data import? #15647
    Shadow
    Member

    Just issue a “SHOW WARNINGS;” command (press F5), this will do the job. I think SQLyog has a built-in menu for this (I don't have access to SQLyog right now).

    April 30, 2004 at 12:59 pm in reply to: Customize status display #15738
    Shadow
    Member

    Currently, no.

    April 30, 2004 at 12:57 pm in reply to: Where clause from join of table #15731
    Shadow
    Member

    Hope I got your questin right: you want to sync the main table, but only those rows which are 'valid' and the validity are determined in another table.

    In this case the answer is no, you cannot use columns from another table (no FROM clause…). In this case, however, you could move the 'valid' field to your main table.

    April 30, 2004 at 12:45 pm in reply to: Mysql/PHP #15739
    Shadow
    Member

    Perhaps you could check out PHP's manual as PHP contains built in support for MySql…

    (Hint: look for functions whose name starts with “mysql_”, such as mysql_connect(DBHOST, DBUSER, DBPASS))

  • Author
    Posts
Viewing 15 posts - 286 through 300 (of 642 total)
1 2 3 … 19 20 21 … 41 42 43