[peterlaursen]

Issues confirmed fixed with beta6.

For those interested they were.

1) Backup/export could fail if column name was also a RESERVED WORD like 'key'.

2) When exporting a very big table the ';' after data of the last row of that table would sometimes be missing (depending on CHUNK, BULK and other settings). This occurred only with HTTP-tunnel.

[peterlaursen]

No TAGS folder is created by the FREE version!

[peterlaursen]

Confirmed with 5.12 beta 5 FREE edition too.

explanation. The .db files are on the ENTERPRISE version the embedded databases (SQLite database) used by the 'autocomplete' feature. The name is a checksum of connection details. One file is created each time you open a new connection.

The file does not make sense in FREE editon, and should not be in root folder!

If it is necessary to have such an empty file for for each connection with the FREE edition then they should go in a /TAGS folder like with the ENTERPRISE version.

[peterlaursen]

@diroddi

If you want us to help you with that you will have to give more information.

If I tell you 'my car won't start – if did before changing the tyres' then what can you do about it?

Could you explain what that job is doing and what the error is?

[peterlaursen]

OK ..

1) The XML-did not have in it what you expected. So that is solved

2) The mapping issue. I don't understand quite if there is an issue or not?

[peterlaursen]

I don't know if this is a Windows thing or SQLyog thing. MySQL Query Browser does correct with your queries as well as mine.

[peterlaursen]

Well also queries that you issue yourself are logged to HISTORY as of now.

Ther are some pending requests regarding HISTORY tab.

* an option to 'switch off' the time information

* HISTORY should (in my opinion) end each equery with a ';' – to make it easier re 're-use' it

* an option to 'save' or 'spool' to a file. And to reload an olde history if needed.

I think Ritesh promised to look into it in 5.2 or 5.3 release. Do you have a precise implementation idea? Some other program doing this as you would want SQLyog to do it (doesn't need to be a database client)?

[peterlaursen]

Quote:

i didn't manually copy the ini file. i assume that it used the one from 4.x install

Your assumption is (or at least should be) correct!

Now I don't understand the problem exactly!? Did you have scheduled jobs using files in the 4.1 installation folder (or a subfolder to it)? And those job do no run anymore or have disappeared from SQLyog 'Job Manager' or …? If yes, are the files still there? Are the jobs still to be seen in 'Task Manager'?

… I can hide away if you want …

[peterlaursen]

hehe … could you explain a little bit about what this query means ? 😮

But SQLyog does exactly as you describe it. MySQL command line client does not.

Now I experienced a little more:

I create a `&&&` table with a `&&&` column (a CHAR type) and entered the value '&&&'.

Next executed

SELECT `&&&` from `&&&`;

The column name is displayed as `&` and not `&&&`.

MySQL command line does:

mysql> SELECT `&&&` from `&&&`;

+

---

+

| &&& |

+

---

+

| &&& |

+

---

+

1 row in set (0.00 sec)

mysql>

Now what the issue is here Ritesh must explain … 😀

[peterlaursen]

Hi ..

I understand that you installed the BETA to another folder than where 5.02 was installed?

Then the path to all files in the Windows Task Scheduler is wrong.

Did you copy the sqlyog. ini file too?

But I actually do not know precisely from where the *Job Manager* reads its data.

[peterlaursen]

just checked it, but no new monitor there 🙁

[peterlaursen]

a 'Select all' and 'deselect all' has been requested before – by me …

I miss it more in RESULT tab than in DATA tab

[peterlaursen]

did you notice the '?!`. What I wrote was mostly meant as an open question (to Ritesh primarily) if the function depended on some OS routines, that did not function on your Windows installation and in case so what could be the reason for this.

Thanks for offering me a new OS .. but I'd prefer to have my new monitor first!

[peterlaursen]

Code:

Will probably fix #6 in BETA 5

To me it looks more like vygi's PC needs an OS repair or reinstall ?!

[peterlaursen]

SQLyog uses no pen. But when you start entering data in the asterix row another asterix row is displayed below. When moving cursor from the row you have been writing asterix changes – indcating that row has been saved!

Now Ritesh must be able to tell/guess whether the missing asterix and the strange thing you reported is the same issue.

@vygi ..

check this issue on another computer. You had 5 licenses at the office?

[Author]

Posts