On: Accidentally destroyed production database on firs...

[h1d]

Not sure why this isn't default in many tools. That's 99% for hazards.

[duskwuff → h1d]

Put the following into your ~/.my.cnf to enable it for the command-line client:

    [client]
    safe-updates=1

[h1d → duskwuff]

Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.