Re: [Wikitech-l] cleaning database of spam

yes that's what I do :> On Tue, Feb 26, 2013 at 4:39 PM, Jay Ashworth <jra(a)baylink.com> wrote: > ----- Original Message ----- >> From: "Platonides" <Platonides(a)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 jra(a)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(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l