[Mediawiki-l] Duplicate a wiki or a wiki database - DELETE users

Tels nospam-abuse at bloodgate.com
Tue Mar 28 17:26:43 UTC 2006


Moin,

On Tuesday 28 March 2006 16:22, Rob Church wrote:
> Deleting users is a double-edged sword. It's simple enough to do in
> SQL but could cause problems when breaking the relational structure of
> the database. A safe option would be to update the archive, revision
> and recentchanges tables, altering the numeric user_id foreign key to
> be 0 for each of the rows corresponding to users you want to delete,
> then deleting them.
>
> This way, MediaWiki treats the user as nonexistent and won't throw up
> bizarre errors in obscure places later on.

Is there a maintainance script to do this?

best wishes,

Tels

-- 
 Signed on Tue Mar 28 19:26:17 2006 with key 0x93B84C15.
 Visit my photo gallery at http://bloodgate.com/photos/
 PGP key on http://bloodgate.com/tels.asc or per email.

 "Für eine solche Bitratenreduktion muss ich den Transcoder so
 umkonfigurieren, dass er gröbere Quantisierungskoeffizienten für die
 MPEG-Matrizen verwendet, Captain" - "An die Arbeit, Mr. LaForge." --
 Jens Baumeister in http://tinyurl.com/oomb

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 481 bytes
Desc: not available
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20060328/c3e41a12/attachment.pgp 


More information about the MediaWiki-l mailing list