How to Clean and Optimise The WordPress Database

Note: Cleaning up the Database is a great way to improve your website speed and reduce the database size. After completing this guide, you may be able to further optimise the database through phpMyAdmin (click here for that guide)

 

Step 1 - Log into WordPress, then Install and Activate the WP-Sweep plugin

bf6d72ce03241cfe30cf492aef7c9b93e81cdb72?t=db8369ad176cc9ec391796e3d53b3726



Step 2 - Click on Sweep under the Tools section

bc3368c9d522db7239dfc9719ec098720eb88be9?t=d45a71f820932e4b10a8120c4ac9b979

 

Step 3 - Take note of this warning. This process is unlikely to cause any trouble, but it's a good idea to be prepared, just in case. All our hosting accounts keep 30 days of backups that you can easily access. Click here for a guide on using our backups to restore the database should things go wrong.

2c5b43b8f111a7bcd28587c980c6bbf4a7f3938f?t=42034d4571ad30eeecbd1926de233bcf

 

Step 4 - Scroll down to the bottom and click Sweep All. if your database is large, this may take a few minutes to complete.

c7c689fd5344f5da6bd08aba8e4f3981c4b25768?t=b9f7dc759b3ed9b4dc237cc6beff95eb



Did you find this article useful?