[peterlaursen]

And finally I tried Mint Linux with both KDE and Cinnamon desktops. Also Wine 1.6.2.  Not reproducible either.

[peterlaursen]

Even in Xubuntu 14.04 (Xubuntu = Ubuntu with XFCE desktop replacing Unity desktop) and Wine 1.6.2, I cannot reproduce. 

 

Well, I only tried with a single small talbe.  But you tell it is always reproducible for you?

 

(edited:  I originally wrote 10.04 and not 14.04)

[peterlaursen]

Not an issue either on Fedora 21 (in neither Gnome and XFCE desktops) and Wine 1.7.30.

[peterlaursen]

Not reproducible in OpenSUSE 12.3 with Wine 1.7.28 and XFCE desktop (running in Virtualbox).  I suspect this is an issue with Ubuntu’s “Unity” desktop.  Or it may be the Wine version.

 

Anyway I have Xubunbu and Fedora as well.  Let me try those.

[peterlaursen]

1) I think that the option to skip session restore is a reasonable request.  I have added it to our issue-tracker here :https://code.google.com/p/sqlyog/issues/detail?id=2069

 

2) if SQLyog is not opened  ‘on top’ of the desktop,  it could be because some other runnng application does something that brings it on top after SQLyog is launched but before SQLyog interface paints

[peterlaursen]

You have probably read replies to similar questions appearing here before.

 

SQLog is a program that makes extensive use of the Windows API (http://en.wikipedia.org/wiki/Windows_API).  This API is a *huge* extension to the C++ programming languages. In the Unix world there are numerous libraries available offering similar functonalities in “small portions” (“curl” for networking, a number of graphics libraries (gtk+ for instance) etc.). But they are *similar* only. They are not a direct replacement. And in SQLog source code a very large fraction of codelines are actually dealing with the Windows API (preparing parameters for function calls etc.). In some cases replacing may be rather trivial (I think replacing wininet.dll with curl would be quite easy) but in other places it would require a complete rewrite of the logic inside the program. It cannot be done by one person in a year. It may take 5 or more man-years.

 

And this would an investment we cannot justify. A lot of Linux users would love a native Linux version (but only if it is free, mostly), and despite the increasing market share of Apple systems we dont believe the revenue from a Mac version would match the investment.

 

So there are still no plans for a Mac version of SQLyog.

[peterlaursen]

Why don’t you concentrate on fixing the server issue (by configuring the server for instance)? How can you expect a client to work when the server does not? 

 

To stop a query, SQLyog will need to create a new connection to the server and execute mysql_kill() with the thread_id of the first connection as argument.

[peterlaursen]

I think then it would not only apply to ‘geometry’ to all datatypes listed here: http://dev.mysql.com/doc/refman/5.6/en/spatial-datatypes.html

 

There will need to be some logic, so that the option for creating a spatial index ‘greys out’ for indexes on non-spatial datatypes, so it is a little bit non-trivial to add.

 

Also I really don’t know if multi-column spatial indexes aoe possble, so also some reseach is required. This is not somethng we know very much about.

[peterlaursen]

Are you simply asking for recognition of the  keywords, so that the formatting settng (capitalization or whatever) would apply for those? 

[peterlaursen]

We will check after the weekend.

 

To make it easier for us can you provide CREATE statement for the affected table (execute “SHOW CREATE TABLE tablename;” It may matter if there is PRIMARY KEY or UNIQUE KEY on the column.  You should never have on FLOAT and DOUBLE columns in MySQL – please refer http://faq.webyog.com/content/29/162/en/tables-with-floating-point-datatypes-fail-to-update.html

[peterlaursen]

We save the *data as stored* in the database.  That is the purpose of a backup. No backup tool has that option. Do you find it in ‘mysqldump, for instance?

 

You can

1) Export a structure-only sql-dump

2) export data to CSV. Here you you can select what columns to be included.

 

Also be aware that

1) if the autoincrement column is the Primary Key of the table (what it often is) then removing it may result in duplicate columns

2) in relational databases the autoincrement will often be used for a Foreign Key (“relationship”). If it does not get created with exactly same value as it originally was, you will break the Foreign keys.

 

 

 

There is no chance that we will include such option in ‘export as sql-dump’. It makes absolutely no sense to me.

[peterlaursen]

The two backslashes in “`palembq\_javasite” look weird! It looks like the client creating this user had some problems with escaping. Or possibly it could be a bug in some early alpha/beta server. What is the server version BTW? 

 

Was it possible that you could try (as root and peferably using command line client or SQLyog) to execute:

GRANT ALL PRIVILEGES ON `palembq_javasite`.* TO ‘palembq_website’@’184.107.100.%’;

 

Also you can see in HISTORY tab of SQLyog what statements it sends to the server for every GUI operation it does. The same statements will fail from the editor (and from any client), right? If this is soem kind of shared server where you don’t ahve access to GRANT you will have to discuss with the server administrator there.

[peterlaursen]

Please connect with SQLyog, execute “SHOW GRANTS;” and and paste the result here.

[peterlaursen]

I can think of two workarunds

 

1) You may install the 2 week TRIAL,  if you did not have it installed on the system before (you can install to another folder). Then you can also have a check of the SQLog ‘powertools’ of commercial editions.

2) Execute the LOAD DATA LOCAL INFILE statement from the editor. Syntax is here: http://dev.mysql.com/doc/refman/5.1/en/load-data.html (don’t miss that a “” in a Windows file path must be escaped like “C:\data\filename.csv”).

 

 

 

It looks like the developer team has left for the day. So i am not able to tell a timeframe for the fix.  It may already have een fixed in our code trunk. But I will update status on Monday.

[peterlaursen]

We can reproduce this – but only when using Community version of SQLyog on Windows 8.1.

[Author]

Posts