Bug #20818 Bookmarks (in subfolder) disappeared
Submitted: 3 Jul 2006 7:10 Modified: 4 Jan 2007 8:46
Reporter: Jan Lund Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version: OS:Windows (WinXP SP2)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Generic

[3 Jul 2006 7:10] Jan Lund
Description:
Bookmarks appear to have disappeared.

How to repeat:
Open two query browsers with different connections (I use one for development and one for production). Run some queries and create bookmarks to them. The following day the bookmarks created (in one of the querybrowers) were gone. I do not know if this happens every time. One thing I should mention though is that I used subdirectories and put the queries therein.
[3 Jul 2006 7:54] Sveta Smirnova
Thank you for the report.

Verifed as reporter described: only bookmarks created in connection window, which has closed last, saved.
[3 Jul 2006 8:11] Sveta Smirnova
As reporter does not specify OS version and I test it on Win XP, I defined Win XP as OS.
[4 Jan 2007 8:46] Mike Lischke
This is a behavior I cannot fix. It is very much the same as with a text file opened in two different editors. If you save it in the first editor and then in the second one you will lose your changes in the first editor. Hence the rule is: you *must not* change configuration data in both QB instances or you will only keep the last state. Decide for one instance to change things. All instances of Query Browser (and in certain cases like connections also all instances of Administrator and Workbench) share the same configuration files so *don't* change this from more than one place.

Btw: this is very similar to how a database handles this. If you have two different clients working on the same data the last change will win.

However, since this is not a very comfortable situation, we consider using a different approach in new tools.
[28 Apr 2008 21:21] Brendan Casey
There is no way to save or import export query bookmarks in mysql query browser for xp.  I can save and export the XML in osx, but i run also on an XP machine, and I cannot even find the bookmarks I made on that machine.  No suck XML file exists.