Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantThere is no difference in COMMUNITY and ENTERPRISE in respect to 'copy to other' functionality.
I am not unwilling to help with this, but I simply have no option to do it! 5.0 was released almost 3 years ago and this is *very long time* in software industry! We kept a copy of 5.19 for reference (the last version before we went open source) and 5.32 (the last non-unicode version for Win 9x compability). Anything before that is irreversible purged, as we do not want to spend time with it!
If you can reproduce or help us to reproduce such issue with 7.11 (COMMUNITY or ENTERPRISE (TRIAL)) or another recent version it will be fixed with high priority. Also you only experience this now only, I understand. Anything special now you can think of, like some specific names (like with special characters) or whatever? You are welcome to attach small dumps here where this happens (observe that .sql files are not accepted so please zip or rename to .txt).
Are you sure that table was physically deleted on source? Maybe only an internal bug of some kind that causes identification of table to fail internally?
We can help with your product key for 5.x. If you are interested please create a support ticket and provide some details that will identify you! You wlll also be able to upgrade to 7.x with discount.
peterlaursen
ParticipantYou can easily duplicate. MySQL (if not compiled with a patch) only logs slow queries in full seconds except for the very latest 5.1 versions that support microseconds (but we don't in MONyog yet – we truncate microseconds away currently!)!
I still do not understand why you would save log details in MONyog. What do you want to achieve with this?
peterlaursen
Participant1) I think we can 'echo' a line to the command line like 'now running job “sja mybackupjob” ..' or even ” “now running job “sja mybackupjob” on database “blahblah” “. Was that it?
FYI and BTW: usually users request the the command-line should NOT display AT ALL. This is achived by running job as another user than the one that is currently logged on! So in that case it will not display of course!
2) We should not allow for characters in job name not valid with the Windows scheduler. If described correctly it is a bug! We will check this!
peterlaursen
ParticipantAlso version 5.0 is now a very old version. It is not supported any more. We cannot do anything about it! how should we be abale to fix issues 'backwards' ?? In principle we only take bug reports with latest stable version! Standard reply: please verify the issue with latest stable version!
However i checked changelogs. For 5.02 it reads “SQLyog 5.02 (January 2006) – Fixed a system crashing bug in “Copy DB to Different Host” option. ” This could be related. But nobody in Webyog today wrote this and I also do not know exact details about it! And actually we do not have a single copy of such old version ourselves anymore, so we are not even able to verify it or comment on it!
We have no such issues with recent versions (+2½ years). That is all I can say! Nobody here has memory beyond that.
peterlaursen
Participantno clue!
peterlaursen
ParticipantQuote:Also I have another server and I cant connect to it using sqlyog.So I think that tells that networking from your Wine is not working properly. WHY I cannot tell!
peterlaursen
ParticipantPlease try MySQL Administrator. If possible try both the Linux version and the Windows version in Wine (if it will install and run in Wine – I am not sure).
You can see here: http://appdb.winehq.org/search_results.php…g&sa=Search
that it works for most people with all brands of Linux.
Maybe an issue with Wine on your Slackware … but when I wrote this FAQ years back:
http://webyog.com/faq/content/31/71/en/can…r-on-linux.html
I tested myself in SuSE10 and a friend of mine did on some Slackware version. And we use and test on various RH/Fedora's, Ubuntu's, OpenSuSE 11 at least.
Do you have an external server somewhere? If so can you connect to this one? If you don't please create a support ticket and I can let you have access to some.
Also: will any program on your Wine be able to connect (to both your Linux system and remote hosts) using TCP. I do not know exactly what you could try, but maybe install Firefox for Windows on Wine and try to connect to a webserver on the Internet and (if you have) a webserver or your Slackware.
peterlaursen
ParticipantYou already read this FAQ I understand!
http://webyog.com/faq/content/23/15/en/err…_t-connect.html
.. but did you also read this:
http://webyog.com/faq/content/23/36/en/i-g…t-connect-.html
.. probably it is the host configuration that causes this trouble. For instance there may be no 'localhost' but a 'localhost@localdomain' defined in host file.
One idea:
Command line will use Socket for connection to MySQL on Linux systems, SQLyog will use TCP. So issue is that TCP connections fails with 'localhost' I guess!
Try “127.0.0.1” as host ('localhost' is simply an alias for the ip '127.0.0.1' – but it needs to be set up in host configuration).
Also you can try the 'MySQL Administrator' program. Can you connect with this one or is it same problem as SQLyog?
Finally you can try add a line in host file defining your own alias. Just a line like
Code:mymachine 127.0.0.1should do and you should be abale to connect using 'mymachine' as host! But you will need to reload host configuration (unless you use some GUI tool that does automatically) or reboot.
BTW: what kind of Linux is this?
peterlaursen
ParticipantI tried to post a new report: http://bugs.mysql.com/bug.php?id=39850
peterlaursen
ParticipantI will not comment more on the coding aspect (but I told that it was *not simple* (like a msgbox() ) – not that it was *very hard*), but FYI we use Win32 API *exclusively* (no Windows Foundation Classes for instance). And this is actually now *very nice* because of Wine compability!
peterlaursen
Participantno .. not required. Let us see what we can do.
This 'no to all' thing is actually not simple because the WIN32 API does not support it directly. It will need to be a custom dialogue programmed from scratch. (the programs where I have seen it I believe are mostly programmed in Delphi).
Personally I think 'no to all' is very relevant, but not 'yes to all' as you will still need to enter the file path to everyone. But you can comment on it …
peterlaursen
ParticipantWe will try to reproduce, but maybe it is some specific setup (64 bit OS + specific graphics hardware and driver) we will need. Did you try install latest/latest stable/an older Nvidia 64 bit driver?
It you move the program ouside the visisble screen area and back again with the mouse does it repaint correctly?
peterlaursen
ParticipantIt seems that 'on_click' works and 'on_doubleclick' is not defined/not functional.
I agree that they should do the same here (same as what click does).
We will check this (on Wndows and Wine)
peterlaursen
ParticipantNext release will be in 20-30 minutes unless something goes very much wrong!
peterlaursen
ParticipantOne more complication is this behaviour
Code:create table tttt(id int);
create temporary table tttt(id int); — note you can have a normal table and a temporary table named the same!
insert into tttt (id) values (1); — it inserted but where? no info avail!
select * from tttt; — there is a table of some kind with data
drop table tttt; — which one was dropped? no info avail!
select * from tttt; — empty set – the remaining table has no data!
show tables; — one row returned so it is the 'normal' `tttt´table that exists
drop table tttt; — success
show tables; — empty setThis was what I reported as a bug to MySQL 2 years ago or so (bug: you can have a normal table and a temporary table named the same).
They down-classified it from 'bug' to 'feature request'.
In the above example the temporary table is given priority by the server. But I am not sure if it always does! All this is simply not documented!
-
AuthorPosts