How to turn Comments on-off

[photopress:mysql.jpg,full,alignright]

This is the best way to turn commenting or trackbacks on or off for all existing posts.

Just do it the database query way:

UPDATE wp_posts SET comment_status = 'closed', ping_status = 'closed';

To return to normal:

UPDATE wp_posts SET comment_status = 'open', ping_status = 'open';

This of course assumes you want all posts open/closed.