Home / wiki / maintenance / archives
Name Modified Size InfoDownloads / Week
Parent folder
upgradeLogging.php 2011-03-17 5.8 kB
patch-watchlist-null.sql 2011-03-17 287 Bytes
patch-watchlist.sql 2011-03-17 1.1 kB
patch-val_ip.sql 2011-03-17 117 Bytes
patch-validate.sql 2011-03-17 514 Bytes
patch-user_registration.sql 2011-03-17 241 Bytes
patch-user_rights.sql 2011-03-17 630 Bytes
patch-user_token.sql 2011-03-17 362 Bytes
patch-user_nameindex.sql 2011-03-17 351 Bytes
patch-user_newpass_time.sql 2011-03-17 154 Bytes
patch-user_properties.sql 2011-03-17 860 Bytes
patch-user_groups.sql 2011-03-17 903 Bytes
patch-user_last_timestamp.sql 2011-03-17 134 Bytes
patch-user_editcount.sql 2011-03-17 204 Bytes
patch-user_email_token.sql 2011-03-17 326 Bytes
patch-userlevels.sql 2011-03-17 250 Bytes
patch-usernewtalk.sql 2011-03-17 626 Bytes
patch-user-realname.sql 2011-03-17 230 Bytes
patch-userindex.sql 2011-03-17 59 Bytes
patch-transcache.sql 2011-03-17 184 Bytes
patch-updatelog.sql 2011-03-17 120 Bytes
patch-tc-timestamp.sql 2011-03-17 210 Bytes
patch-templatelinks.sql 2011-03-17 588 Bytes
patch-trackbacks.sql 2011-03-17 263 Bytes
patch-ss_images.sql 2011-03-17 216 Bytes
patch-ss_total_articles.sql 2011-03-17 179 Bytes
patch-rev_text_id.sql 2011-03-17 488 Bytes
patch-searchindex.sql 2011-03-17 1.1 kB
patch-ss_active_users.sql 2011-03-17 117 Bytes
patch-rev_len.sql 2011-03-17 65 Bytes
patch-rev_parent_id.sql 2011-03-17 218 Bytes
patch-restructure.sql 2011-03-17 3.9 kB
patch-rev_deleted.sql 2011-03-17 306 Bytes
patch-redirect.sql 2011-03-17 979 Bytes
patch-rename-user_groups-and_rights.sql 2011-03-17 297 Bytes
patch-rd_interwiki.sql 2011-03-17 189 Bytes
patch-recentchanges-utindex.sql 2011-03-17 229 Bytes
patch-rc_len.sql 2011-03-17 219 Bytes
patch-rc_type.sql 2011-03-17 445 Bytes
patch-rc_user_text-index.sql 2011-03-17 173 Bytes
patch-rc_id.sql 2011-03-17 151 Bytes
patch-rc_ip.sql 2011-03-17 190 Bytes
patch-rc-newindex.sql 2011-03-17 216 Bytes
patch-rc-patrol.sql 2011-03-17 211 Bytes
patch-rc_deleted.sql 2011-03-17 359 Bytes
patch-querycachetwo.sql 2011-03-17 776 Bytes
patch-random-dateindex.sql 2011-03-17 2.2 kB
patch-querycache.sql 2011-03-17 463 Bytes
patch-querycacheinfo.sql 2011-03-17 292 Bytes
patch-protected_titles.sql 2011-03-17 459 Bytes
patch-pt_title-encoding.sql 2011-03-17 301 Bytes
patch-profiling-memory.sql 2011-03-17 79 Bytes
patch-profiling.sql 2011-03-17 342 Bytes
patch-page_restrictions_sortkey.sql 2011-03-17 315 Bytes
patch-parsercache.sql 2011-03-17 409 Bytes
patch-pl-tl-il-unique.sql 2011-03-17 493 Bytes
patch-page_props.sql 2011-03-17 231 Bytes
patch-page_restrictions.sql 2011-03-17 762 Bytes
patch-page_len.sql 2011-03-17 572 Bytes
patch-pagelinks.sql 2011-03-17 1.8 kB
patch-oldestindex.sql 2011-03-17 228 Bytes
patch-oldimage-user-index.sql 2011-03-17 190 Bytes
patch-objectcache.sql 2011-03-17 255 Bytes
patch-oi_metadata.sql 2011-03-17 812 Bytes
patch-mime_minor_length.sql 2011-03-17 352 Bytes
patch-mimesearch-indexes.sql 2011-03-17 1.3 kB
patch-log_user_text.sql 2011-03-17 401 Bytes
patch-math.sql 2011-03-17 942 Bytes
patch-log_search-rename-index.sql 2011-03-17 317 Bytes
patch-log_search.sql 2011-03-17 423 Bytes
patch-log_deleted.sql 2011-03-17 138 Bytes
patch-log_id.sql 2011-03-17 360 Bytes
patch-log_params.sql 2011-03-17 65 Bytes
patch-logging-times-index.sql 2011-03-17 162 Bytes
patch-logging-title.sql 2011-03-17 253 Bytes
patch-logging.sql 2011-03-17 1.3 kB
patch-linkscc.sql 2011-03-17 265 Bytes
patch-linktables.sql 2011-03-17 2.1 kB
patch-langlinks.sql 2011-03-17 386 Bytes
patch-linkscc-1.3.sql 2011-03-17 197 Bytes
patch-job.sql 2011-03-17 717 Bytes
patch-l10n_cache.sql 2011-03-17 261 Bytes
patch-ipb_optional_autoblock.sql 2011-03-17 244 Bytes
patch-ipb_range_start.sql 2011-03-17 1.1 kB
patch-ipb_emailban.sql 2011-03-17 119 Bytes
patch-ipb_expiry.sql 2011-03-17 372 Bytes
patch-ipb_anon_only.sql 2011-03-17 1.9 kB
patch-ipb_by_text.sql 2011-03-17 311 Bytes
patch-ipb_deleted.sql 2011-03-17 129 Bytes
patch-inverse_timestamp.sql 2011-03-17 613 Bytes
patch-ipb_allow_usertalk.sql 2011-03-17 126 Bytes
patch-ipblocks.sql 2011-03-17 180 Bytes
patch-interwiki-trans.sql 2011-03-17 86 Bytes
patch-interwiki.sql 2011-03-17 695 Bytes
patch-img_width.sql 2011-03-17 469 Bytes
patch-indexes.sql 2011-03-17 656 Bytes
patch-img_metadata.sql 2011-03-17 207 Bytes
patch-img_sha1.sql 2011-03-17 292 Bytes
patch-img_exif.sql 2011-03-17 114 Bytes
patch-img_media_type.sql 2011-03-17 889 Bytes
patch-image_name_primary.sql 2011-03-17 164 Bytes
patch-image_name_unique.sql 2011-03-17 165 Bytes
patch-fix-il_from.sql 2011-03-17 438 Bytes
patch-hitcounter.sql 2011-03-17 272 Bytes
patch-image-user-index.sql 2011-03-17 191 Bytes
patch-filearchive-user-index.sql 2011-03-17 203 Bytes
patch-filearchive.sql 2011-03-17 2.0 kB
patch-external_user.sql 2011-03-17 326 Bytes
patch-fa_deleted.sql 2011-03-17 158 Bytes
patch-eu_local_id.sql 2011-03-17 91 Bytes
patch-externallinks.sql 2011-03-17 285 Bytes
patch-email-authentication.sql 2011-03-17 140 Bytes
patch-email-notification.sql 2011-03-17 829 Bytes
patch-drop-user_newtalk.sql 2011-03-17 216 Bytes
patch-drop_img_type.sql 2011-03-17 97 Bytes
patch-change_tag-indexes.sql 2011-03-17 929 Bytes
patch-change_tag.sql 2011-03-17 1.2 kB
patch-cache.sql 2011-03-17 1.4 kB
patch-category.sql 2011-03-17 413 Bytes
patch-categorylinks.sql 2011-03-17 1.3 kB
patch-categorylinksindex.sql 2011-03-17 325 Bytes
patch-backlinkindexes.sql 2011-03-17 529 Bytes
patch-bot.sql 2011-03-17 437 Bytes
patch-ar_len.sql 2011-03-17 63 Bytes
patch-ar_parent_id.sql 2011-03-17 127 Bytes
patch-ar_deleted.sql 2011-03-17 137 Bytes
patch-archive-user-index.sql 2011-03-17 206 Bytes
patch-archive-rev_id.sql 2011-03-17 164 Bytes
patch-archive-text_id.sql 2011-03-17 502 Bytes
patch-archive-page_id.sql 2011-03-17 189 Bytes
Totals: 130 Items   67.9 kB 4
== MediaWiki Maintenance ==

The .sql scripts in this directory are not intended to be run standalone,
although this is appropriate in some cases, e.g. manual creation of blank tables
prior to an import.

Most of the PHP scripts need to be run from the command line. Prior to doing so,
ensure that the LocalSettings.php file in the directory above points to the
proper installation.

Certain scripts will require elevated access to the database. In order to
provide this, first create a MySQL user with "all" permissions on the wiki
database, and then set $wgDBadminuser and $wgDBadminpassword in your
LocalSettings.php

=== Brief explanation of files ===

A lot of the files in this directory are PHP scripts used to perform various
maintenance tasks on the wiki database, e.g. rebuilding link tables, updating
the search indices, etc. The files in the "archives" directory are used to
upgrade the database schema when updating the software. Some schema definitions
for alternative (as yet unsupported) database management systems are stored
here too.

The "storage" directory contains scripts and resources useful for working with
external storage clusters, and are not likely to be particularly useful to the
vast majority of installations. This directory does contain the compressOld
scripts, however, which can be useful for compacting old data.

=== Maintenance scripts ===

As noted above, these should be run from the command line. Not all scripts are
listed, as some are Wikimedia-specific, and some are not applicable to most
installations.

	changePassword.php
	Reset the password of a specified user

	cleanupSpam.php
	Mass-revert insertion of linkspam

	createAndPromote.php
	Create a user with administrator (and optionally, bureaucrat) permissions

	deleteOldRevisions.php
	Erase old revisions of pages from the database

	dumpBackup.php
	Backup dump script

	edit.php
	Edit a page to change its content

	findhooks.php
	Find hooks that aren't documented in docs/hooks.txt

	importDump.php
	XML dump importer
	
	importImages.php
	Import images into the wiki
	
	importTextFile.php
	Import the contents of a text file into a wiki page

	moveBatch.php
	Move a batch of pages 

	namespaceDupes.php
	Check articles name to see if they conflict with new/existing namespaces

	nukePage.php
	Wipe a page and all revisions from the database

	reassignEdits.php
	Reassign edits from one user to another

	rebuildImages.php
	Update image metadata records

	rebuildmessages.php
	Update the MediaWiki namespace after changing site language

	rebuildtextindex.php
	Rebuild the fulltext search indices

	refreshLinks.php
	Rebuild the link tables

	removeUnusedAccounts.php
	Remove user accounts which have made no edits

	runJobs.php
	Immediately complete all jobs in the job queue

	stats.php
	Show all statistics stored in the cache

	undelete.php
	Undelete all revisions of a page

	update.php
	Check and upgrade the database schema to the current version

	updateRestrictions.php
	Update pages restriction to the new schema

	userOptions.php
	Change user options
Source: README, updated 2011-03-17