Spooling Out
Jump to navigation
Jump to search
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