MySQL 4.1.11
Remote connection, no tunnelling

Steps to reproduce
1. Connect to a single DB
2. Run a slow running query
3. Click Stop

Try and run the query again and I get

Error Code : 1046
No database selected
(0 ms taken)

And it is SQLyog 5.2 RC2 ?

umm help about says 5.2 Beta 11

Reproduced here now too.

We are (re)searching ....

Fixed in the development tree.

Issue was that is the query did not use `database`.`table` notation but only `table` notation, the latest USE statement got lost if SQLyog reconnected - what it frequently does with so-called 'slow servers'.

Now it will USE the database shown in the combo-box in such situation.

Hmm I wonder what has changed... I have only noticed this new behaviour lately (ie the last 1 or 2 releases..) perhaps my server has turned into a so-called 'slow server'

I shall not tell what happened. it need not be the MySQL server. Could be a trivial harware issue (cable, router, switch , transmitter) as well.

If you are in control of the server you can enable the 'general log' by inserting something like

log = mylog.log

in the [mysqld] section of the my.ini/my.cnf file and you can see how often it reconnects.