Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantIt is no new request.
But if it shall be done properly it should be based on 'knowledge' of SQL.
Currently SQLyog is 'ignorant' about SQL … it has to ask the server every time!
I think we should discuss the priority of this and similar requests after the 6.2 release.
peterlaursen
ParticipantI do not know what happened, but know I can see the image. Probably it was because it was a little big and took some time to transfer!
With a reasonable image format , 'cut', and compression you could have saved our server 20MB of diskspace. It is rather easy to tell the same message with around 100KB! Please observe!
peterlaursen
Participant1)
I think the image did not come? Could you try attaching again?
2)
Please read:
http://dev.mysql.com/doc/refman/5.0/en/comp-err.html
You are sure that the error message file used in that system is not chinese?
It does not do with other clients? Please try an erroneous query from command line client (just “SELECT blahblah”!).
Execute on a Linux shell (do not connect from a Windows machine). Alternatively try MySQL Query Browser ..
3)
What is wrong about Chinese? It is a very informative language! 🙂 Jokes apart .. we have no such reports before!
I think this must be a configuration issue on your system or a silly mistake with the MySQL build distributed with that distro!
peterlaursen
ParticipantYou did not overlook anything. We do not have this option yet.
There is not a single 'XML format'. XML is a formal standard on how to use tags only – there are several ways to store data in XML. Anyway I agree that at least we should be able to import the .xml format that we export ourselves. I think this was a repetition of a previous reply …
Are you aware of any approved or 'de facto' standard of XML data storage that we should support?
I do not know 'Basecamp data' .. details .. link?
peterlaursen
ParticipantI have no problems with “SELECT now()” in SQLyog.
[attachment=819:now.gif]
The only issue I can see is that “SELECT 'this is a literal 20 times'” will violate the buffer containing the HEADER if the returns of 'this is a literal 20 times' is longer than 64 characters. Because with such query (with no alias) the header is identical to data themselves!
We do not handle a HEADER size > 64 chars properly. Of course we will fix it. That I told already. Only such issue is that buffer/memory handling can (in C/C++) involve quite a lot of 'low level' programming. For that reason we may decide to fix in the 6.2 trunk and not the 6.16 trunk.
peterlaursen
ParticipantPlease confirm that you SELECT 'a quoted string'.
The reason for this crash is that we expect only column headers of up to 64 characters. That is the max. size of a column name in MySQL. However we probably overlooked that when we are not SELECTing from a database – but selecting a literal string instead – a longer header can occur, and that condition/expection is not handled properly.
So this buffer issue occurs with the column header and not with data. Also not with an ALIAS >64 characters!
If this is not what you are trying to tell then please detail!
peterlaursen
ParticipantI think you meant
“select '0x00000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000'”
with singlequotes?
We have reproduced this (except that on a single machine running Vista ServicePack1 (RC) it does not!). Maybe the OS buffer protection was improved .. maybe some other reason …
Please try an alias like
“select '0x00000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000' as something”
This works for us on all systems!
But you are right of course that this is a bug. And we will fix this. I cannot guarantee in 6.16 but no later than 6.2.
peterlaursen
ParticipantDoes not crash for me with 6.16 beta 1 on Vista.
[attachment=818:select.gif]
… but what is the idea of that select?
peterlaursen
ParticipantYou can try SQLyog with the Wine ports available for Mac OS-X ('darwine' and 'CrossOver for Mac').
Search 'Wine' in this Forum for more details!
peterlaursen
ParticipantI wonder if you have some adaptor permanently attached to the VGA/DVI port?
Please also reply the question to the extend that you can!
peterlaursen
ParticipantIn 6.2 it will be possible to select individual SP's and other objects (not only tables) for copy and export operations.
peterlaursen
ParticipantCould you guys please tell how this is a SQLyog-related question?
There is no Forums, mailing list or simailar available for this 'WoW Private Server'? We cannot know the thousands of applications that use MySQL!
However we have a FAQ on this error 1045:
http://webyog.com/faq/content/23/18/en/err…on-denied-.html
One idea: you can try to skip the configuration wizard, The installation folder will contain .ini file templates named like my_medium.ini etc) rename one of them to my.ini and try start the server from command line with “net start mysql'.
peterlaursen
ParticipantIt DOES reconnect.
However with SSH tunnel the complete connection chain SQLyog<>PLINK<>SSHD<>MySQL is not 'reinstantiated' – only SQLyog<>PLINK is.
Reconnecting/reinstantiating the complete connection chain will be implemented in version 6.2.
Are you using SSH tunnel?
peterlaursen
ParticipantWithout going too much into detail (because I am not a coder) I would say that you will need to start writing a parallel to the MySQL C-API (libmysql.dll). And that is not a simple task!
peterlaursen
ParticipantJerryL wrote on Jan 23 2008, 09:22 PM:I have about the same problem as the previous user… but the nl solution doesn't work… neither does n or l or nr or AUTO or any of my other attempts to snag this by trial and error.PSPAD says the records in my file end with hex B6 which they call ¶. My table is large, so I am using WINRAR, but the database doesn't seem to have a problems with that. It also has no trouble restoring an entire database created the same way, or a smaller single table non-compressed table also created by the same software. I'm running out of ideas… and shudder at the though of splitting the table into 6 or 7 noncompressed chunks… ugh! Any thoughts? Is there any documentation for the corect way to enter the line control parameters into the box (abbreviations, hex codes, actual characters?) Oh, I also tried putting a ; at the end of each line and entering that in the line termination box… result was too many fields in first record error message.
First i will ask you to add to the topic. braching liek this is very confusing (and I would wish the Forums software eitehr supported it better or did not support it at all!) I posted a reply reading
“did you try 'rn' ('cariage return' followed by 'newline')?
This is DOS/Windows standard for linebreak (Unix/Linux is 'n' only).
You could inspect/view the file in a HEX editor! If you do not know how to do this, just attache a small example (please zip before attaching).”
Now I think you understand a HEX editor. anyway a small example/test case is much better than words!
-
AuthorPosts