[Frizzled]

Sorry for the late response, I dropped in while debating another year's subscription –

I think I understand why this working this way now: to save USE DB calls you are assuming the last table clicked (in any tab) is always the current table. This assumption was fine before tabs were added to SQLYOG, but with tabs you have an application that is begging for multi-tasking (it's kind-of the whole point of having different tabs), but you have a program that still has a single task mind-set.

How about having SQLYOG remember the used database by tab, then compare the database it's supposed to run the current query on in the active tab with the database of the last query (in what-ever tab that was)? If the databases match you've saved a USE DB call, if they don't just throw one in.

… OR (even easier) save each current table in Table Data by Query tab then always run a USE DB call, but *only* when the user switches away from Table Data and back again (ie. they run a statement, then want to go from Results back to Table Data).

I suppose all this is moot, years ago (literally) I asked that Shift+Click reverse sort fields in Table View and was told that was going in with the next build (I think that was in version 5 or 6) … with that not in yet I'm not going to hold my breath on this issue 😉

_f

[Frizzled]

'Aparna' wrote on '24:

when there are multiple Query tabs, the table data tab displays the last selected table irrespective of which Query tab you move to.

Correct, you can best see this behavior if you switch between Results (after running a query) and Table Data views on different tabs. The tabs do not save which Table Data view they were using, they will all use the last Table Data view you looked-at.

_f

[Frizzled]

Sounds great! I'll keep my eye out for the Beta =)

_f

[Frizzled]

Thanks! =)

[Frizzled]

Awesome! 😀

Thanks Ritesh!

[Frizzled]

Hmmm,

Thanks for the reply.

It's not quite what I was hoping for. <_< I'd rather have all the data, instead of just the last three days. I take it if I choose to append each backup to the same file, then I can save all the data. Unfortunately, that sounds like it's going to be a major pain when I try to sort through it to find a certain day's backup. I'll dig around as-well to see if there's some way to rename the file automatically, thanks for your help 😀 _f

[Frizzled]

I'm just using the default settings, so it's local port 3306 and ssh port 22 for the remote DB.

The localhost DB does not have the SSH tunnel box checked.

I'm pretty sure this is a bug (although, it could still be my fault 🙂 ), because if I reverse which one I connect to first (connect to localhost first then connect to remote with SSH tunnel) I don't get an error.

But, if I connect to the remote first (SSH tunnel), then I connect to my localhost – I get the error and the message is coming from the remote DB.

_f

[Author]

Posts