3.8.9. SQLRecoveryFile Previous topic Parent topic Child topic Next topic

This feature is known not to work as expected with some types of database. Its use is deprecated: you are strongly discouraged from using this feature. Support for it may be removed in future versions.
This optional parameter specifies the name of a file where any failed SQL do queries aree logged, perhaps for later recovery. The default is no logging. The SQLRecovery-File file is always opened written and closed for each failed SQL do query, so you can safely rotate it at any time.
Make the file name depend on the date. This way, all the missed accounting records per day are located in a single file.
Here is an example of using SQLRecoveryFile and logging all failed queries of one day into a one file:
# Log all failed SQL queries to a log file per day
SQLRecoveryFile %L/sqlfailures-%Y-%m-%d