Some people like to clean up their database by deleting every single table row individually, which takes a lot more time than using a plugin. Not these fields to clean up the database, more filters are available like comment, user, meta fields, terms, etc. This will delete any posts in draft mode or scheduled for future publication, as well as old revisions from previous versions of a post that is no longer needed after you publish an article once. However, click on any option that you want to clean or schedule. To enable scheduled cleaning, you need to set this by individually. Then clean up post revision, trash, and autosave with just a single click.īesides, you can set a s cheduled cleaning process. Then go to the WP Bulk Delete menu, which is located on the left sidebar of the WordPress dashboard.
So download the plugin, then upload and activate like other plugins activation processes. To clean the WordPress database manually, you can use a plugin called WP Bulk Delete that lets you clean the entire WordPress database or delete anything from WordPress quickly. You can clean a WordPress database manually by deleting spam comments, post drafts, and other unnecessary data from the WordPress dashboard.
You should always make sure that there is a backup before doing any cleanups! How to Clean WordPress database Manually? You can also use it to export an SQL file and run a batch query on all of the tables if you need to repair them manually. Read: How to Restore WordPress Site with BackupBuddy? Easy Guide
You can read another guide on BackupBuddy vs Duplicator. This plugin has a built-in scheduler to automatically backup your WordPress Database at scheduled intervals like every day, week, or month. The plugin BackupBuddy is the best for backing up a database. Backup Your WordPress Database Before Cleaningīefore cleaning a WordPress database or an optimizing database, you should backup the database first. You can use other plugins if desired, depending on what cleaning needs. To make this process easier, there are plugins that will help with these tasks! There are many plugins available, but I recommend WP-Optimize or WP Rocket for general usage because both are easy and effective. This is done by deleting the comment and removing its ID from one function in your WordPress database. Spam Comments: If you have many spam comments on your blog, it may be time to clean those.Here, you can use iThemes security plugin that lets you alert about Inactive users in real-time. People who have not logged into their accounts for over thirty days. Inactive Users: You can remove inactive users from your blog’s database because they will use up disk space on your hosting server.
These should be optimized regularly to clean out any spam or abandoned entries.