Spooling Out

Thanks to my friend LW for helping sort this one out.

You can increase the verboseness (is that a word?) of a batch output logfile in MySQL, by repeating the "-v" switch.

This is amazingly useful if for example you are running some DML and wish to capture in your output logfile the number of rows being inserted/deleted/updated.

mysql -u user -ppassword database_name -v -v < test.sql > test.log