The WordPress database might get bloated, especially if you tend to use many plugins, test out new interesting ones and change themes often. You might want to clean it up or even wipe it out entirely to start fresh. You don’t have to delete your entire WordPress installation and create a new one to do this, you can just reset your database using a plugin.
WordPress Database Reset
WordPress Database Reset is a small and easy to use plugin which allows you to reset your database. Once you install and activate it, you can go to Tools > Database Reset to check out its very simple interface. There you can select a particular table to reset or, if you wish so, the entire database. Fill in the security code and click the reset button. That’s it, your database ( or selected table ) will be reset.
WARNING: Resetting a table or the entire database will result in loss of data, any content or settings stored in the selected tables will be gone forever, please make sure you know what you are doing, have backups and or do not care if loss of data occurs.