Zinn® SEO how-to: Clean up your WordPress database safely

Clean up your WordPress database safely

Measure what can go, back everything up, and clean up old revisions, expired data, spam, trash and leftovers in small batches, with one-click undo.

1. Measure what can be cleaned — Go to SEO, Site care, Database, and press Measure what can be cleaned. Nothing is removed: you see how many rows and how much space each kind takes.
2. Choose what to clean — Tick the kinds to clean: expired temporary data, old revisions (the newest of each page are kept), automatic drafts, spam and trash, data left behind by deleted pages, comments, users and categories, finished background tasks and table space.
3. Back up and clean — Tick that you have looked at the sizes and press Clean up. Every row is backed up before it goes, and with Zinn® Backups a full database backup is made first. It works in small batches, so even a very large site stays fast.
4. Settings loaded on every page, and undo — Below, the largest settings WordPress loads on every page view are named with the plugin they belong to: stop loading one that a removed plugin left behind. Press Undo this whole run to put everything back, and choose a weekly or monthly clean-up under Schedules and alerts.

With a screenshot of every step: https://zinnseo.com/kb/clean-up-your-wordpress-database-safely