Turning on trace messages for Perl DBI

To turn on the trace messages for debugging database calls with the Perl DBI all you have to do is set a environment variable like so:
export DBI_TRACE=1

Now run your Perl program and you will see details of every database query.

This will last for the current session only, but to turn it off issue:

export DBI_TRACE=0

Last updated: 28/09/2005