Shrink WordPress Database Size

I need an experienced MySQL-savvy WordPress specialist to slim down my site’s database. The priority is the table structure: pruning or merging columns that no longer serve a purpose, tightening up indexes where they genuinely speed queries, and converting table formats only if it helps reduce footprint without breaking plugins.

Beyond structural tweaks, I also want every trace of duplicate or otherwise needless data purged so the final .sql export is significantly lighter. A quick before-and-after size report will confirm the gains.

Deliverables
• Cleaned and optimized database dump (.sql)
• Short changelog outlining removed columns, index adjustments, and data-cleanup actions
• Before / after size comparison

If you are comfortable working through phpMyAdmin, WP-CLI, or direct MySQL access and can complete the job without disrupting live traffic, let’s get started.

The current size of the database is 5.5GB and due to my hosting company I have to reduce it to less than 1GB.

I will only pay for completed job, that means if you are not able to reduce the size of the database that will be consider as uncompleted job and I will not pay for the service.