title: Can I require confirmation on all destructive operations on a MySQL database?
body: <p>I have a local MySQL database I'm playing with manually. I can use the <code>safe-updates / i-am-a-dummy</code> options to disallow unqualified delete statements:</p>
  
  <pre><code>DELETE FROM table;
  </code></pre>
  
  <p>However, I can still easily lose everything with an accidental</p>
  
  <pre><code>TRUNCATE TABLE table;
  </code></pre>
  
  <p>as this latter statement is not prevented by <code>safe-updates</code>. Apart from backing up the database, what's the best way to prevent data loss here? Is there some way to require confirmation before <em>all</em> destructive actions, not just delete?</p>