Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantJust a short additional comment from here!
Quote:SQLyog first uploads the file and than executes the scriptNope! SQLyog is compiled with the MySQL client API. The script is executed from the client! It does not 'upload' in the sense that there is no file transfer.
Please also answer: with what program was the .sql script generated?
ParticipantThe import tool creates a seperate connection to the import.
We need a small sample dump here! Just a small database with two tables and a few rows in each!
Please create such, zip it and attach it here!
It is a complete mystery what happens! Never experienced or heard about this before!
ParticipantQuote:and I suspect all the SQL statements were executed to another DB.Does the file contain a 'USE' statement? If so it will of course use what the statement says!
Now we have an issue with 'conditional comments' like /*!40101 comment_as_statement */ that are widely used by 'mysqldump' program for instance. SQLyog 'import' cannot handle it (it runs OK from the editor). This is a known bug that will be fixed in 5.2 tree and most likely in beta2 or beta3. So it is likely you simply had an error!
ParticipantQuote:it did not workYou will have to be more specific in describing the possible error. It is NOT a miscalculation in the verirication of the trial period, because then it would have displyed something like “Your trial period has expired …”
You are quite sure it was not an 'error 40' ?
Participant.zip package with includes uploaded now!
ParticipantQuote:The MySql and Scintilla include directories are emptyA mistake on our side. Sorry for that.
Be patient for a short while. We will upload a new .zip with the includes in a few minutes
ParticipantI am sorry to disappoint you.
… but 'Viborg' is not 'Vyborg'. 'Vyborg is an old Swedish/Finnish spelling of 'Viborg'. Viborg is in Denmark and Vyborg is located close to the Finnish/Russian border.
Vi or Vy means 'holy/sacred place' in the ancient nordic language spoken at the time of the Viking Era. Viborg probably was the most important religious place in Denmark before christianity arrived!
ParticipantPlease refer to:
http://webyog.com/faq/34_102_en.html
When connecting with SQLyog try choosing some cyrillic charset in the connections manager 'dropdown' and not 'default'. Most likely cp1251 would be best choice. You should be able to display latin and cyrillic characters at the same time. But you will need a recent SQLyog version to have the 'dropdown' option.
Cyrillic character sets in MySQL: http://dev.mysql.com/doc/refman/5.0/en/cha…illic-sets.html
Is your windows localisation Russian or English?
BTW: we do intend to use UNICODE internally with SQLyog very soon!
.. and please attach the graphics files directly. The WORD document is hard to read!
ParticipantStarting from SQLyog 5.17 we do use the same DELIMITER format as the programs from MySQL AB.
Please refer to: http://webyog.com/faq/33_7_en.html
What is the version you are using?
But this:
Quote:So there must be something non standard going on in SQLYog here... is not true. there is NO STANDARD for the DELIMITER syntax at all! The DELIMITER statement is NOT an SQL statement and it is not sent to the server! It is implemented in the client only. The purpose of the DELIMITER statement is that is shall be possible to distinguish whether a ';' (semicolon) seperates SQL-statements or not. It would be fairly possible for a graphical client to use coloring, indentation, or different fonts or whatever for this!
But we did – after multiple requests – adopt the syntax from MySQL AB in SQLyog 5.17!
ParticipantQuote:I do run it on Fedora Core 5 with varying degreees of success but compared to the same installation running on a Windows machine – well, it's rather pedestrian and comes up with an assortment of issuesCould you explain those issues please! My personal experience with SqLyog running on Wine/SuSE (10.0 and 10.1) is that SQLyog performs better here than it does on Windows! But I also think that SuSE has more 'dedicated' support for Wine than FEDORA has.
However we have an older FEDORA (3 or 4 – I do not remember) at our Bangalore Office running Wine 0.9.2. Here are no problems either.
There are two known issues with SQLyog on Wine:
1) Favorites: you can edit favorites and save a favorite, but not paste into the editor and thus a favorite is not of much use!
2) autocomplete: the CTRL+ENTER and CTRL+SPACE shortcuts do not work on Wine.
If you still have the Wine that shipped with Fedora5 try updating it by entering 'yum install wine' from a command shell.
Actually you see still more cross-platform software being built on Wine – such as Google Picassa. We have been discussing building our own 'yogwine' that only contains the Wine components that we need and that are fully stable. For instance we do not need 3D-graphics and sound support. Also as Codeweavers have now launched beta1 of their DarWine port of Wine for Mac-OS-X I think that we will see wine 'grow' considerably in short time. Also Wine on Solaris and HP-UX are 'accelerated'. And the FreeBSD/PC-BSD version is pretty much up-to-date.
CodeWeaver's announcement: http://crossover.codeweavers.com/pipermail…ust/000033.html
ParticipantYou will have to build a batch file with more instances of the SJA like described here:
http://webyog.com/faq/27_35_en.html
Once you got one jobfile you can easily generate anotehr by 'search and replace' in a text editor.
A more advance solution is to execute the SJA from within an aplication/a script that does a 'loop'. Inside this loop you will then basically have two statements
1) execute SJA
2) replace in the jobfile
ParticipantQuote:it seems to be a bug in the trial expiration calculation…If it has expired it willl tell you so!
ParticipantI wish I could answer this!
anybody else?
ParticipantConfirmed!
Not intentional of course! We will put it back!
@Manoj: would it be a 'big deal' to add a 'rename' option in the context menu?Participanthmmmm …..
I do not think that 10% of MySQL servers in use yet are MySQL 5.x.
But obviously we should keep an eye with this posibility and the developments.
A small SQLite table holding the time of last rebuild that could be compared with the value in I_S and skipping tables that have not changed is absolutely a possibility. And for those people having thousands of tables with hundreds of columns it does make sense!
I do not believe in using Information_Schema 'on the fly'. SQLite is undoubtly faster with remote servers at least. I cannot tell what query SQLyog sends to get the columns-list with MySQL 5, but somebody else must be able to.
But one thing is certain and that is that querying MySQL Information_Schema is not fast as of now. 'SHOW' statements are much faster! This bug: http://bugs.mysql.com/bug.php?id=19588 is very much a 'show-stopper' for MySQL 5.
-
AuthorPosts
