In my first job as a software engineer I was working on an inventory management system for the University I attended. The original source for the data was a wacky Access database. We had a copy of the data imported into MySQL in production and it was not uncommon for me to try something, corrupt my local database, and need to restore it from backup.
When doing so I would typically run "TRUNCATE items;" on my local and repopulate it with the content from the not-yet-live production copy. This worked great until the afternoon where I was doing a demo for my boss in the office, realized my local datastore was in a bad state, and then got my tabs for "production" and "local" mixed up in my terminal. I truncated the entire dataset on production while my boss was standing behind me.
I got to learn a lot about how to export from Microsoft Access and import to MySQL that month. Lol.
When doing so I would typically run "TRUNCATE items;" on my local and repopulate it with the content from the not-yet-live production copy. This worked great until the afternoon where I was doing a demo for my boss in the office, realized my local datastore was in a bad state, and then got my tabs for "production" and "local" mixed up in my terminal. I truncated the entire dataset on production while my boss was standing behind me.
I got to learn a lot about how to export from Microsoft Access and import to MySQL that month. Lol.