[peterlaursen]

I think there are other priorities right now.

But I also think it will not be extremely difficult to implement a 'exclude.db' SQLite database with names of databases and tables that should be excluded!

[peterlaursen]

I complained about the same thing when SQLyog 5.0 was released, but it was explained to me that this is basically an issue with MySQL – and not SQLyog!

There is no way to get a nicely formatted VIEW definition returned by MySQL as it is with a Table.

We have been 'counting on' that MySQL would realize that there is a need for this! Actually they have improved a little with Stored Procedures since the first MySQL 5.x release..

We will not spend our own time with this .. at least not for the foreseeable future. But maybe we should consider to 'push' MySQL a little in that direction!

[peterlaursen]

1)

“But in SQLyog I can create a stored procedure that references a table that doesn't exist”

No, that is wrong! Correct is “In MySQL I can etc…”. If the server does not reject it, SQLyog does not either. And should not!

2)

” … move from the development environment to the test environment and ultimately to production, all that needs to be scripted are the 10 new procs. Is there a way to accomplish this that I'm missing?”.

I do not understand the problem. If you compare the databases and there are not other differences than that, then the script generated would only add those 10 procedures.

Basically when querying information about tables no information about SP's, FUNCTIONs, VIEWs or EVENTs is sent by MySQL. SQLyog cannot generate CREATE statements about objects it has no information about.

… but … well … maybe I understand a little anyway. I suppose that the tables are organized in databases another way in the development environment and the production environment? That would typically be the case if you have only one database available at a webhost, but have organized the development environment into more databases. Something like that? Also in the development proces you may have created some tables or other structures that are in (unfinished) development and that you do not want to sync to the production environment yet.

Well, I think you have a point. But it also is a little bit dangerous to play around with … But I think it is technically possible.

[peterlaursen]

Quote:

No worries, I'm dumb, problem fixed.

Sorry, but that is not enough qualify for a discount 😀

[peterlaursen]

Actually I do not know how much code involved here is SQLyog code and how much is native Windows code.

tomorrow morning when our office gets populated again, they may be able to tell more.

If you have 'systems estore' enabled you could try to reestablish a restore point from some time back.

[peterlaursen]

This

“After a few weeks of using Enterprise more or less to my satisfaction (is it my imagination, or does plain old SQLyog work better than Enterprise?), I've been getting rude surprises from SQLyog Enterprise. The main one is that whenever I hit the F5 key to execute a query, I'm prompted to save the contents of the tab. Then, even if I click “No”, I'm given a file dialog.”

.. is not reproducable here. Looks like when pressing the code to 'close tab' is getting executed. We have 1000's – probably 100.000's – SQLyog 5.1x users and this was never reported before.

Could I ask you to try a fresh install (could be to another folder) and see if problem persists?

[peterlaursen]

Refer to: http://webyog.com/faq/33_20_en.html:

“There are plans for a GUI SQL-builder as you find it in Office Suite -type databases.”

As we don't have the limitations of a web-interface as phpMyAdmin has, we should be able to create a better graphical environment.

[peterlaursen]

BTW: just download from the BETA link in the 'News' section.

Not announced yet .. but you'll get BETA4 that fixes the issue with the tunneller.

[peterlaursen]

1)

The 'bug':

This is not a bug! We have been discussing this several times before! Search a little around the Forums!

The implementation of DELIMITER in MySQL command-line client and SQLyog is simply DIFFERENT. And that is it!

DELIMITER is not an SQL-statement, is not handled or understood by the server and is implemented in the CLIENT only. Basically a client supporting SP's will need to be able to distinguish between delimiters

1) INSIDE Stored Procedures

2) BETWEEN SQL statements

… and that can be done in dozens of different ways .. and does not even need to make use of the word DELIMITER at all. You could imagine using the typography (coloring, italics for instance) only.

Also refer to: http://webyog.com/faq/26_49_en.html

But it would be nice if SQLyog supported the MySQL comman-line syntax as well.

But line-breaks are insignificant in the editor component of SQLyog (unlike command-line), and that is why is is not so simple!

2)

the 'Feature request':

Due to the organisation of the MySQL system databases (the 'mysql' and 'INFORMATION_SCHEMA' databases) this is not possible. ROUTINES (SP's and FUNCTIONS), VIEWS and EVENTS are database objects, TRIGGERS are table objects.

Of curse it could be 'coded around' somehow, but that would also be a little dangerous as the user will then have to secure for himself that all tables needed by the SP's are selected. We do not parse the CREATE definition of a SP – simply query the system databases. As any client supporting SP's (including MySQL AB's own GUI tools) does.

[peterlaursen]

1)

CSV-issue is fixed in BETA4 (I just tested it 1 hour ago). Just use the latest link from the *News Section*.

And let me explain: to generate the CSV/text fil SQLyog simply executes

“SELECT .. into outfile … (optionally) enclosed by … terminated by .. escaped by …”

If escaped by is '' (empty string) it writes NULL values as 'NULL' (without quotes) to the file.

If escaped by is anything else (try ^ for instance) NULL values are written as 'N' (also without quotes) what is also understood by LOAD DATA INFILE.

You see very little is done by SQLyog itself here – it just executes MySQL standard commands. But there was a bug that is now fixed.

Now a small improvement with beta 4 is that no matter if you enter '' or '\' as escape character, SQLyog now does the same: it uses '' as the escape character. What is sent to MySQL is ” … escaped by '\'” – and as '\' is an escaped '' it will use '' as the escape character. Just as you will have to send “INSERT … 'backs\ash' …. ” to the server to insert the string 'backsash'. 🙂

It has confused 'newbie' users a lot over the years that the escape character '' itself also must be escaped like '\' in the 'Esport as CSV' settings dialogue. As of Beta 4, you may escape it or not – or put another way both '' and '\' in the settings dialogue makes SQLyog use the escape character ''. It sends ” … escaped by '\'” to MySQL.

2)

We have absolutely no reports of similar screen-issues with any 5.x. And 5.0 is soon one year old and has been downloaded by 100.000's of users. I still suggest you try updating/reinstalling graphics drivers. And updating Win2k to at least SP3 is probably a good idea too .. for several reasons – including security.

Are you using some (IMHO crap) hardware like Logitech replacing the original Windows drivers? Do you have the chance to try with the most simple hardware – no bluetooth, no USB, no wireless. Plain cabled PS2 with original Microsoft drivers!

We need a detailed information of graphics card, mouse and keyboards (hardware as well as drivers) if we shall have a chance to go further into this.

[peterlaursen]

hehe .. nobody readily admits that their system is 'sick' <_< We have two issues to discuss. 1) SQLyog CSV-export with NULL values:

Could that be done better?

Is this a MySQL issue or a SQLyog issue?

Or will it never be possible to get a reasonable CSV-export with NULL values?

I think Ritesh should comment on it. I know exactly what the program does when it imports CSV but not exactly what it does when exporting CSV!

2)

The display issue with mouse-cursor and keyboard-cursor not 'synchronizing'

Is it possible that you could try reinstall your graphics drivers?

Do it the 'tough way:

1) Boot into VGA-mode

2) Uninstall graphics drivers

3) Boot into VGA-mode

4) Install graphics drivers and configure the display

5) Boot normally.

BTW:

What is you graphics system (graphcis card, driver version) etc?

Newer driver available?

When installing 5.x you don't need to overwrite 4.1. Just install to another folder.

[peterlaursen]

“I'm running 5.2 on Win2K”

Do you mean that you are running SQLyog 5.12 on Win 2K?

On Win2K we always need more info! SP-level?, a 2K-server or a 2k-'ordinary'? There are so many 2k-variants …

“I didn't have this problem with 4.1.”

Exactly what problem did you not have with (SQLyog) 4.1?

Do you mean that the 'mouse-cursor' and the 'keyboard-cursor' is not synchronzied, so that keyboards writes in another cell than mouse selects?

This is what I understand from your pictures.

No other program does similar things? Spreadsheet programs for instance?

.. my first inpression is that your system must be sick ….

How goes the CSV-thing?

[peterlaursen]

Tested with MySQL 4.0 and old SQLyog versions as well.

Same result – NULL becomes an escaped N like \N and imports as 'N' to a char/varchar field whether quoted or not.

When imported to a numerical field it becomes 0 (sero), unless some strict SQL-mode is used .. if so an error will occur.

But actually I am in doubt whether the CSV format is fit for handling NULLs at all ??

This

1,”Admin”,NULL,””,529

and

1,”Admin”,NULL,””,NULL

… would work for 'load data infile' with MySQL, but what happens if you open it in Excel?

Excell does not know about NULL .. it is inserted as a text-string, I believe

And now I CAN make it read the 'optional' checkbox. My head on vacation or a GUI bug that does it does not always check for it – with certain combinations of/sequences of operations? But the 'N' still is a mystery to me!

[peterlaursen]

Regarding the NULL issue with CSV …

This is an example of a line in a CSV file generated by SQLyog

“1”,”Admin”,\N,””,”529″

— note that NULL is written as \N

— even if I check 'optionally' numbers like 529 are enclosed! They should not.

Are they bugs with SQLyog or have the OUTFILE parameters changed with MySQL 5 ??

and “\N” import as the string “N” for instance

the line should simply read like

1,”Admin”,NULL,””,529 — and it import easy

but it is not possible to generate such line, because the 'optional' is ignored and NULL becomes an escaped N.

Why the hell write an escaped N for NULL ???? 😮

This was tested with MySQL 5.0.21.

Something went wrong with the the introduction of 'fill Excel frienly values' of 5.0 ???

[peterlaursen]

There are two ways to import CSV:

1) You may import into a table from the table menu

2) or you might use the Migration 'powertool' with the Microsof text-ODBC-driver.

Which one do you use?

You are sure that NULLs are not made ZERO when you generate the CSV? Did you inspect the file?

And are the NULL's quoted like “NULL” or 'NULL' and how are your settings?

From which program do the data come?

You are also sure that the column is not defined as 'NOT NULL' ?

Could you post here:

* a small CSV-file with such NULLs

* the corresponding SQL-dump after import

* a screenshot of the CSV-import settings (if you use the import tool)

(zip it altogether in one file)

BTW: we have a FAQ:

http://www.webyog.com/faq/28_73_en.html

and BBTW: there may be more efficient ways than using CSV-format – but all depends on what is the source.

[Author]

Posts