To turn on trace you just need to call the trace method with the level you want to use:
$dbh->trace(3);
# rest of your code here.
Then check your logs. Start with a level of 3 and go up as needed from there if you don't get enough info. Again, I'm not really sure what that will do for you. The error you're getting is coming from MySQL and I'm not sure if you will actually get anything worth while traced *before* you get to that error. Do you also have access to the MySQL logs to see what might be going on?
~Charlie
Code:
my $dbh = DBI->connect(...); $dbh->trace(3);
# rest of your code here.
Then check your logs. Start with a level of 3 and go up as needed from there if you don't get enough info. Again, I'm not really sure what that will do for you. The error you're getting is coming from MySQL and I'm not sure if you will actually get anything worth while traced *before* you get to that error. Do you also have access to the MySQL logs to see what might be going on?
~Charlie