News for hackers. Stuff that matters.
Re:Safely Dropping MySQL Tables by mathnode on Monday July 25, 2022 @04:49PM (#32230728)
You are spot on. And more importantly, a roll back procedure.

In this case, RENAME TABLE x TO y, and watch or wait for a process to fail in test/QA/UAT/etc.

Have a DROP ready, but also a RENAME back.

A production quality MySQL or MariaDB installation should have enabled binary logging and maybe delayed replication to handle any issues.

There are no comments on this comment yet.