Rename SQL log file

simbabque posted 7 years ago in Running SQL scripts
In a previous version of Heidi I was somehow able to set a nameing template for the SQL log file but I cannot remember how that worked. There are log files in my directory from a couple of months ago that have a name like [server name][number].log (eg "readonly 000001.log"). Version 6 of Heidi deactivated the file logging and when I just turned it on again it names the files 0000001.log and so on.

I use a lot of different connections so I very much like to have different, recognizable log files for each of them. How can I change the file names again?

Thanks for your reply.
ansgar posted 7 years ago
Logfilenames were never customizable, only they were named like the session you have opened, and there was one file per session, closed when you closed HeidiSQL. Newer HeidiSQL builds allow multiple sessions in one application instance, so the session name was no longer the name of the logfile. Instead, the logfile now contains the session name per line, as a prefix, so you can see which query was fired by which session.
simbabque posted 7 years ago
Ah, great. Now it makes sense. Thanks a lot! smile

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