MySQL Bugs: #23670: History and bookmarks overwriting

Bug #23670	History and bookmarks overwriting
Submitted:	26 Oct 2006 15:23	Modified:	5 Jan 2007 13:18
Reporter:	Lorenzo Grio	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.4 beta	OS:	Windows (WinXP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
If you have more instance of Query Browser, history doesn't work properly because only history of last closed instance have saved and all new history of not-last instance are lost!
Bookmarks has same problem.

How to repeat:
1-Run first instance of Query Browser and execute a query:
  SELECT * FROM mysql.db d;
2-Run second instance of Query Browser and execute another query:
  SELECT * FROM mysql.host h; 
3-Close first instance of Query Browser.
4-Close second instance of Query Browser.
5-Run new instance of Query Browser, in History you will find ONLY this query (executed from last instance closed):
  "SELECT * FROM mysql.host h;"

Suggested fix:
Write history on disk as soon as a query is executed (open file, write history, close file).
Write bookmark on disk as sono as a bookmark is inserted.

Thank you for the bug report.

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #20818.