Forum Replies Created
-
AuthorPosts
-
peterlaursenParticipant
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!
peterlaursenParticipantQuote: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.
peterlaursenParticipant@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.
peterlaursenParticipant@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!
peterlaursenParticipantYour gmail refused the attachment. But the other one should be OK.
peterlaursenParticipantIt 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!
peterlaursenParticipantQuote: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.
peterlaursenParticipantYou can PM me a mail adress to mail it to!
peterlaursenParticipantyeah … its is crazy!
Is your mailbox big enough for 5 MB ?
peterlaursenParticipantI 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.
peterlaursenParticipantQuote: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.
peterlaursenParticipantthe version no. IS available from help … about.
peterlaursenParticipantAs 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! ๐
peterlaursenParticipantQuote:…. SQL file created by SQLyog Ent. 9.01 beta.SQLyog Ent. 9.01 beta ….
Where did you get if from ๐ ๐ ๐ฎ ๐ ๐ฎ ๐ ๐ ๐
peterlaursenParticipantCaught 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 ๐
-
AuthorPosts