----- Original Message ----- > From: "Platonides" <platoni...@gmail.com>
> > What is exact procedure of properly removing page from database so > > that it doesn't break anything? What needs to be deleted and in > > which order? > > maintenance/deleteArchivedRevisions.php permanently removes the > content of deleted pages from the db. > > For removing those users, see > http://www.mediawiki.org/wiki/Extension:User_Merge_and_Delete > > Also remember that due to the way mysql works, it may not release > those 20GB back to the filesystem. In particular, to get anything for your trouble, you will probably need to dump the database, drop it, shut down MySQL and switch it to innodb tablespace-per-file, turn it back on, and then reload the dump, as I recently had to. This way, at least, once you clean it up, you can do the same dump and reload procedure on only one table, not the whole shootin' match. Cheers, -- jra -- Jay R. Ashworth Baylink j...@baylink.com Designer The Things I Think RFC 2100 Ashworth & Associates http://baylink.pitas.com 2000 Land Rover DII St Petersburg FL USA #natog +1 727 647 1274 _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
