Forum Replies Created
-
AuthorPosts
-
January 23, 2013 at 9:49 am in reply to: Help Needed With Creating A Log Of Files In A Folder #34121
peterlaursen
ParticipantOK .. I understand.
I think maybe the application that saves the files should write a log?
January 23, 2013 at 8:08 am in reply to: Help Needed With Creating A Log Of Files In A Folder #34119ParticipantWell .. this is actually more an application-like question than a SQLyog (or MySQL) question, I think. No client does such thing directly and the MySQL server does not either.
Also the MySQL server does not have functionalities to access to the files system except for writing its own logs etc..
What option I see is to execute (dependng on the OS) system commands like “dir” or “ls” parse the output, create a CSV file and import the CSV file to MySQL. But most Unix/Linux users would probable write a small Perl, Python or similar script that both parses the output from “ls” command and inserts to MySQL (and thus avoiding an intermediate CSV file). In either case it will involve a little traditional programming.
And for clarity: you are welcome to ask such questions here, but we at Webyog do not help with users' application programming. And I don't think you should expect much help in this respect from other users here either.
ParticipantIf the statement generated really is like “ALTER TABLE `my_table`, DEFAULT CHARSET='utf8'” it is a bug. There should not be a comma before 'DEFAULT'.
it is also a little inconsistent that we quote 'utf8' in one context and not in another (but cosmetical as both are valid)
January 21, 2013 at 4:47 am in reply to: Table Dropped When Used Copy Table To Another Database #34111ParticipantThere has not been any activity on this, except for Friday where we tried for several hours to reproduce this. We cannot. We have never seen this ourselves and have no other reports like this since the one back in 2008. Can you give some hints – for instance:
1) For how long did you have the program open when that happened, and do you remember what operations you had done before that?
2) You are using COMMUNITY version. This only allows for direct connections unless you establish a tunnel of some kind with some other program (Putty/Plink, some VPN software etc.). Do you?
3) Any 'oddities' with database and table identifiers/names (national and rarely used characters)?
4) Are you copying to another server or another database on same server?
5) Anything else about the environment that is non-trivial/unusual you can think of?
Please also tell MySQL server version(s) involved.
'Provoking the error at will' seems quite hopeless as we have tried for hours. The way forward will have to be by code review, I think. However it will be like seeking a needle in a haystack. So if you can reply to above questions it may limit the search to a corner of the haystack.
One possibility is that a specific (and rare) series of operations by user in the GUI causes a DROP statement to be executed before the USE statement,
ParticipantNO .. no luck in reproducing this.
1. Do you have an option to try another mouse?
2. Could you try with a minimum of other applications (including background programs) running?
3. Are you sure that the MS driver is the right driver for this mouse?
ParticipantYes .. no problems at all.
MariaDb have introduced a few featrues that are not available in 'vanilla' MySQL – notably 'virtual columns' and 'dynamic columns'. We do not have any GUI functionality to handle those yet in our CREATE/ALTER TABLE dialog, but from the editor you can define them like in any text-based client.
Participanthave you considred using transactions?
1) Type in the editor “START TRANSACTION;” and execute.
2) Now manipulate what you want to manipulate
3) Next either “COMMIT;” or “ROLLBACK;”
You will then need to use InnoDB tables. What is saved to the server is actually not saved to tables but to a log and only when you COMMIT changes will be written to tables. And only from then on other clients will see the changes you did.
ParticipantCurrently SQLyog sends an UPDATE or INSERT statement when
1) user presses save button
2) when cursor in GRID moves to the row above or below current row.
And actually I think all GRID based database management tools do like we do in 2). At least I don not know any that don't It is also what users familiar with spreadsheets would expect.
But I will understand this as a request to queue the UPDATE (and possible INSERT) statements and only fire the statements on save button press. There could also be a preview and edit option (for instance we could open an Editor tab with the statements). Do I understand correctly?
ParticipantOK .. when you wrote “when connecting to new db” I understand you mean “when connecting to new server”. The terminology confused. Waht you have here are 2 different connections (it is actually the same as when you have 2 SQLyog instances open).
We have not seen this in our own testing and have no similar reports, but we will try to reproduce it. If you find a way to reproduce it on demand please provide more details or accept the invitation to a shared session.
ParticipantBesides it is not correct that a 'tab for a database' will appear. In the upper area there is a tab for each open connection (and each connection may access one, more or all databases on the server connected to). Also connections do not communicate with each others. If you want to work with 2 databases (and only 2) at a time specify the names of the databases in the connection manager separated with “;” and that particular connection will have access to the 2 databases specified.
Maybe this image explains?
[attachment=1847:conn_manager.jpg]
ParticipantYou should also tell the SQLyog version you are using.
If you think that a (static) screenshot will not explain, we can arrange a shared session. In that case please contact us at [email protected]
ParticipantActually MySQL/Oracle just published a Blog about this:
https://blogs.oracle.com/mysqlinnodb/entry/repeatable_read_isolation_level_in
ParticipantParticipantVersion 10.5 releases notes from http://faq.webyog.com/content/33/7/en/sqlyog-version-history.html: “New major feature: 'Visual Data Compare' (in short 'VDC'). It is a third option for Data Sync in addition to the two already existing ('one-way synchronization' and 'two-way synchronization'). A VDC-job is started from a modified version of the Data Sync wizard (from the 'powertools' menu). With VDC you will be able to compare differences visually and specify tables and rows that shall be sync'ed as well as to decide in what direction to sync. A SQL preview is available. VDC is an ULTIMATE feature.”
And glad to hear that you like it!
ParticipantI have repled in your ticket.
-
AuthorPosts
