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