Retrieving my sql console scratch file.

Found it.

here is the path, in case somebody else is looking for it:

C:\Users\[... your user...]\AppData\Roaming\JetBrains\IntelliJIdea2020.1-backup\consoles\db\[... some id looking like a UID. Mine is:852d1437-1d26-4fa4-8696-0e7698a2ca0b...]

Thats working, thank you :)

Found more elegant interface method ;)

Right button to DB → navigation → Jump to Query Console. In the new window move cursor to “all” and will see all the consoles.

OR

There is a folder structure on the left, and there is an item at the very bottom “Scratches and Consoles”. There are “Database consoles” and all consoles are there. It is even easier. 

So useful, thanks Jetbrains ;)

This may work if you simply close the file, but if you have reset pycharm, this is not possible and this directory is empty. Therefore, the question arises whether it can be restored?

I suggest that in the future you develop an update that does not wipe all data, but resets only the development environment itself, without affecting the executable files.

Artem Syvohlaz Could you please elaborate on how you reset the IDE? If all the configurations have been removed for good without backup, then it is what it is as it has been removed from the local file system. Otherwise, please check this comment.

Check the config folder of the previous versions. There should be a folder called consoles/db inside where you will find your old consoles. You can then copy them over to the same folder in the new version.