Manual:CleanupUsersWithNoId.php

Details
cleanupUsersWithNoId.php is a maint-scripts>Special:MyLanguage/Manual:Maintenance scripts|maintenance script that cleans up tables that have valid usernames with no user ID. It should once be run in wikis that contain imported revisions or global blocks via the CentralAuth extension.

Example
This will only clean up the revision table.

Help
php cleanupUsersWithNoId.php --help

Cleans up tables that have valid usernames with no user ID

Usage: php cleanupUsersWithNoId.php [--assign|--batch-size|--conf|--dbgroupdefault|--dbpass|--dbuser|--force|--globals|--help|--memory-limit|--mwdebug|--prefix|--profiler|--quiet|--server|--table|--wiki]

Generic maintenance parameters: --help (-h): Display this help message --quiet (-q): Whether to suppress non-error output --conf: Location of LocalSettings.php, if not default --wiki: For specifying the wiki ID   --globals: Output globals at the end of processing for debugging --memory-limit: Set a specific memory limit for the script, "max" for no limit or "default" to avoid changing it   --server: The protocol and server name to use in URLs, e.g.        http://en.wikipedia.org. This is sometimes necessary because server name detection may fail in command line scripts. --profiler: Profiler output format (usually "text") --mwdebug: Enable built-in MediaWiki development settings

Script dependant parameters: --dbuser: The DB user to use for this script --dbpass: The password to use for this script --dbgroupdefault: The default DB group to use. --batch-size: Run this many operations per batch, default: 100

Script specific parameters: --assign: Assign edits to existing local users if they exist --force: Run the update even if it was completed already --prefix (-p): Interwiki prefix to apply to the usernames --table: Only clean up this table