Cleanup Duplicate Meta gives you a tool to check for and delete duplicate Post and/or User Meta entries in the database tables.
There are times when your database gets filled up with duplicate entries that you may not want. Cleanup Duplicate Meta allows you to check for any duplicates in either the Post Meta or User Meta tables. Then if you want to get rid of them, simply click on the Cleanup button and Cleanup Duplicate Meta deletes the duplicates leaving either the first or last meta (you select which).
The interface is simple and easy to use:
See the screenshots tab for more details.
The plugin's page in Tools > 'Cleanup Duplicates'.
Screen for both the Post Meta and User Meta controls.
An example of the table generated when clicking on 'Check for Duplicates' button. The results are sorted by meta key.
After clicking on the 'Count Duplicates' button, notification is displayed of the number of duplicates found (which could be deleted).
The message after clicking on 'Cleanup Post Meta'.
Simply click on the ‘Check for Duplicates’ button and the plugin will report the count back to you on the screen.
See the screenshot 2 for an example.
If you know which one you want, then select either the first or last one. Otherwise, leave it at the default.
Yes. Before you run Cleanup, you should backup your database.
Yes!
Nothing. Cleanup Duplicate Meta does not touch non-duplicates. Therefore you’re data remains intact.