Is there anywhere that a comprehensive log or history of statements executed by the user or on behalf of the user is kept? Like for instance I want to see all of the queries I ran 2 days ago.
I have seen the SQL history and View > Output windows, but these only seem to store tab or session history.
Is there any way for me to turn on some kind of client-side logging for every statement?
SQL History / Logging
-
alexa
Re: SQL History / Logging
Logging can be turned on as follows:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. The *.log file can be found in the directory:
Also, you can view logs on the 'SQL Log' tab of the 'Output' window that can be invoked by selecting 'View -> Output' from the main menu.
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. The *.log file can be found in the directory:
Code: Select all
%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\