Thread:Project:Support desk/Reducing the size of mediawiki database

MediaWiki 1.19.9 PHP 5.3.10 MySQL 5.5.37

I have a mediawiki site which has a very large database size ( 11 GB). I want to deploy the site onto a development server. But the development server has limited resources like disk space. So I want to reduce the size of the database to 200MB.

I tried a couple of things 1. i ran the deleteBatch.php and deleted 80% of the pages and categories in my wiki 2. I ran deleteOldRevisions.php --delete and deleted all old revisions

Earlier the size of my database was 11GB and now its only reduced to 9.5 GB which is really strange.

Can anyone tell me what am I missing here? Or whether there is a better way to reduce the size of the database? I am aware of compressing the text to reduce table sizes, but I do not wish to compress the text.

Ys, Arnab