Query History is missing

Hi guys,

I experienced a very bad issue. Heidi has cleared my query history for a specific MySQL server. The other servers seems to be ok. I didnt backup my queries so it is very unpleasant

Of course I've enabled query history and setted it up to keep history for 150 days.

Is there a way to restore my lost history?

Do you know what happend or what goes wrong ?

Thanks

Forgot to mention that I am using HeidiSQL 10.2.0.5599 for Windows. MySQL server version is 5.6.40 ...

Not sure that this matters, but I have lots of queries logged on this server and some of them are big enough.

Query history is bound to a HeidiSQL session. So you might have recreated that session for the specific server, with a fresh and empty history?

You can check with regedit.exe, if the history is still stored:

HKEY_CURRENT_USER\Software\HeidiSQL\Servers\<Your Session Name>\QueryHistory\

Hi ansgar,

Thank you for your answer.

You are right, i have made changes to the settings, cos i wasnt informed it will drop the history :(

I check the regedit, but it keeps the history since i've made the aforementioned changes.

Is there any other options ?

If the history is still there in another session, you should use exactly that session to connect to your server. This will show the history again.