I Accidentally Deleted 7TB of Videos Before Going to Production

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by Moru on Thursday May 05, 2022 @10:09AM (#31273552)

My mistake was on floppy disc with source code, other text files and images. Was hand editing (in hex disc editor) the floppy to get back the data, sector by sector. Fun times. Not going back there though :-)

[ Parent | on HN ]

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by nso on Thursday May 05, 2022 @10:13AM (#31273605)

Mine was a DELETE FROM Users; WHERE... Fun was had.

[ Parent | on HN ]

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by codegeek on Thursday May 05, 2022 @10:23AM (#31273737)

Usually the recommendation is to not start writing the DELETE query first. Write the SELECT query first and see the results. If you miss the WHERE clause, you will see that immediately. Then change SELECT * to DELETE. But I assume you have learned that lesson already :)

[ Parent | on HN ]

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by Moru on Thursday May 05, 2022 @10:34AM (#31273873)

Yes, but it can't be stressed enough, always the first time for someone.

[ Parent | on HN ]