Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Query History is missing

thespecialist's profile image thespecialist posted 3 weeks ago in General

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

thespecialist's profile image thespecialist posted 3 weeks ago

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.

ansgar's profile image ansgar posted 3 weeks ago

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\



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
thespecialist's profile image thespecialist posted 3 weeks ago

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 ?

ansgar's profile image ansgar posted 3 weeks ago

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.

Please login to leave a reply, or register at first.