If you find yourself scratching your head, wondering why that mod_rewrite rule isn't working as you'd expect you can add a logger by simply adding the following to your vhost:
RewriteLog '/var/log/apache2/rewrite_log' RewriteLogLevel 4
So I just ran into an issue where I am trying to recreate a trigger, I drop the trigger and get an error telling me the trigger already exists e.g.
DROP TRIGGER IF EXISTS test_trigger;
I could overcome this error by specifying the table name e.g....