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

Forum Replies Created

Viewing 15 posts - 6,226 through 6,240 (of 7,398 total)
  • Author
    Posts
  • in reply to: Scheduled Jobs #19845
    peterlaursen
    Participant

    I am not sure about what you see ('svhost window' doesn't mean anything to me).

    So I can't tell if it is normal or not.

    Please drop a screenshot!

    in reply to: Engine=innodb Default Charset=latin1 #19842
    peterlaursen
    Participant
    Quote:
    Its SQLyog which creates the .sql file.

    yesyes .. but what I meant was that the .sql file starts with the 'create statement for the table' as returned by MySQL. And it is that part of the .sql file that creates the problem with import.

    in reply to: Engine=innodb Default Charset=latin1 #19837
    peterlaursen
    Participant

    @geza …

    when the sql-file is created no one can tell where it will be used. And BTW the is no way to make the server not include this. It should then be 'stripped away' when imported to 3.x or 4.0. Well that is theoreticaly possible. But as of now the SQLyog code does not parse – or even read – the .sql at all. And I personally think that there are many more important things to do.

    There are lots of editor programs available where you can define this 'search and replace' operation as a macro. I just created one with Textpad http://www.texpad.com in less than a minute. It is just recording it like a Word or Excel macro. A Textpad is a pretty simple program compared to others.

    The basic thing to understand is the SQLyog – being a MySQL client – actually does very little by itself. It controls what the server should do! And thus only things that the server can do can be done with SQLyog.

    But yes … this 'macro' capability could be implemented in the SQLyog editor as well as in any editor.

    in reply to: Engine=innodb Default Charset=latin1 #19835
    peterlaursen
    Participant

    @ritesh .. you should read the question before you answer! ๐Ÿ˜›


    @turigeza
    .. it can't be otherwise A table definition in MySQL 4.1 and 5.0 has pr. definition charset and engine definition with it. Before it has not. When SQLyog queries the server for the table structure this information is returned.

    Search 'ENGINE=InnoDB DEFAULT CHARSET=latin1' and replace with '' (empty string) takes less than 10 seconds in an editor. Besides you can use ODBC import instead if you don't want that.

    SQLyog is a MySQL client. It should not 'overrule' the server. And can't and doesn't!

    in reply to: Download Issues #19822
    peterlaursen
    Participant

    Your gmail refused the attachment. But the other one should be OK.

    in reply to: Download Issues #19821
    peterlaursen
    Participant

    It is on its way out from here now!

    I zipped the file. It is compressed allready, so it does not become significantly smaller, but it is different!

    in reply to: Character-set Problem When Connecting To Server #19830
    peterlaursen
    Participant
    Quote:
    Is this database-related ?

    Yes it is!

    You can read her for instance: http://dev.mysql.com/doc/refman/4.1/en/charset.html . It is similar for mySQL 4.1 and 5.0. And much different than 3.23 and 4.0!

    With MySQL 4.1 and 5.0 SQLyog starts querying the server for the default character set. However ' the default character set' is only a DEFAULT character set. You might have data that don't follow defaults. For instance if data were created when you had other defaults or if they were imported from another server having other defaults.

    There are default character sets (and collations) for the server, for each database, for each table and for each column! So you can have one column in Chinesse and another in English (even ๐Ÿ˜€ – believe it or not but somebody use that ridiculous language! ).

    You can most easily change the default character set for the server with MySQL Administrator” from http://dev.mysql.com . From the left-hand menu it is “startup variables” .. “advanced” tab. See attached. The server must be restarted for the changes to take effect. Charsets for Databases, tables and columns are defined with a CREATE or ALTER statement.

    in reply to: Download Issues #19820
    peterlaursen
    Participant

    You can PM me a mail adress to mail it to!

    in reply to: Download Issues #19818
    peterlaursen
    Participant

    yeah … its is crazy!

    Is your mailbox big enough for 5 MB ?

    in reply to: Download Issues #19816
    peterlaursen
    Participant

    I have no problems. There is no FTP.

    This looks like a server communications problems

    I threw a copy on my personal webiste.

    http://www.deepeter.dk/SQLyog50.exe

    Is that better ?

    Drop a note when you got it.

    It shall not stay there forever.

    in reply to: Sqlyog Doesn't Refresh #19765
    peterlaursen
    Participant
    Quote:
    BTW resizing or moving window did not help in my case.

    That could because your graphics card and driver is more advanced than my on-board graphics chip. Maybe yours can rearrange polygons without having to repaint them completely.

    in reply to: Feature Request … Auto-update #19813
    peterlaursen
    Participant

    @tdunning

    the version no. IS available from help … about.

    in reply to: Escaping Problem In "export Db As Sql Statements" #19808
    peterlaursen
    Participant

    As I see it it IS correctly escaped! this ' (apostrophe) must be escaped – this ร‚ยด (accent) must not. SQLyog and MySQL on Windows sees that it is a ร‚ยด and does not escape. Rightly so!

    However when the SQL is sent to MySQL on Linus, MySQL sees it as a ' – and thus an escaping error.

    The crazy thing is that putting the file into a text editor transforms the ร‚ยด to a ' . After that it is escaped (as it should be) and works on both platforms.

    Where does Vygi live? Which Windows does he use (version and localisation) ?

    And does the editor support the same language? And it is not an 'old model' that works with some extended ASCII only? (I can tell that in Denmark we have tons of problems with the pipe | character, because in 'extended ASCII' it was mapped to Danish letter 'รƒหœ'.

    If Vygi's language uses ร‚ยด for accents for instance ….

    Vygi .. help us … or move somewhere else! ๐Ÿ˜€

    in reply to: Escaping Problem In "export Db As Sql Statements" #19806
    peterlaursen
    Participant
    Quote:
    …. SQL file created by SQLyog Ent. 9.01 beta.

    SQLyog Ent. 9.01 beta ….

    Where did you get if from ๐Ÿ˜› ๐Ÿ™‚ ๐Ÿ˜ฎ ๐Ÿ˜† ๐Ÿ˜ฎ ๐Ÿ˜• ๐Ÿ˜‰ ๐Ÿ˜Ž

    in reply to: Sqlyog Doesn't Refresh #19762
    peterlaursen
    Participant

    Caught in the act! See attached!!

    I did as it was described. Opened 4 different connections, minimized SQLyog program window, and the 'normalised' it again.

    However at the very same moment the the screen-grapper that I use ( http://www.share2.com/capture/ )had 'grapped' the active SQLyog window SQLyog refreshed ๐Ÿ˜• .

    Also resizing the SQLyog program window a little makes it refresh. But that of course would also trigger a repaint command with the video driver. This is tested on my mini-PC 'DAISY' that is a mini-ITX based computer with a VIA Nehemiah processor and 512 MB RAM of which 16 MB is shared Video memory (the best PC I ever had!).

    With more graphics memory and 'game-type' Video-cards it may not occur. However at offices 16 MB (or even less!) shared video memory is not unusual. People are not supposed to play 3D-games at work ๐Ÿ˜€

Viewing 15 posts - 6,226 through 6,240 (of 7,398 total)