Back Up Before You Clean: Using DB Optimizer Safely
DB Optimizer’s cleanup tools delete data permanently. This guide explains why a backup matters first, how DB Optimizer teams up with Duplicator Pro to remind you, and the safe order to do things in.
The short version
Most of what DB Optimizer clears out is genuine junk you’ll never miss. But cleanup is permanent. Once you confirm it, the items you selected are gone from the database and you can’t get them back from inside the plugin. A current backup is your safety net, so if you ever clear something you actually needed, you can put it right back.
It takes two minutes, and it turns a one-way action into one you can walk back.
Why a backup really matters here
- Cleanup can’t be undone in the plugin. There’s no recycle bin once a cleanup finishes.
- Trashed posts and comments are real content. Emptying them is permanent.
- Table operations touch live tables. Optimizing reorganizes your data, which is safe, but it’s still a change to your database.
With a backup in hand, whatever happens, you can roll your site back to exactly how it was a moment ago.
Taking a backup with Duplicator Pro
If you have Duplicator Pro installed:
- Open Duplicator Pro » Backups.
- Create a new backup and let it finish.
- Check that it completed successfully before you head back to DB Optimizer.
No Duplicator Pro? Use whatever backup method your host or another plugin gives you. The only thing that matters is that you’ve got a fresh, complete, restorable backup before you start cleaning.
The backup warning banner
When Duplicator Pro is installed, DB Optimizer keeps an eye on your backups for you. On the Cleanup tab, it shows a warning when:
- It can’t find a backup, or
- Your most recent backup is getting old.
Treat that banner as your cue to grab a fresh backup before you carry on. If there’s no banner, your recent backup is in good shape.
The safe order to work in
- Back up first. Take a fresh Duplicator Pro backup and confirm it finished.
- Look before you confirm. On the Cleanup tab, double-check the counts and the items you’ve selected.
- Read the confirmation box. It names the action and warns you whenever a deletion is permanent.
- Start small if you’re unsure. Clear the obviously safe stuff first (expired transients, embed cache, spam comments), then move on to revisions and trashed content.
- Optimize tables last. Once the cleanup’s done, reclaim your overhead on the Table Management tab.
