maintenance/deleteSelfExternals.php

   1 <?php
   2
   3 require_once("commandLine.inc");
   4
   5 print "Deleting self externals from $wgServer\n";
   6 $db = wfGetDB(DB_MASTER);
   7 while (1) {
   8         wfWaitForSlaves( 2 );
   9         $db->commit();
  10         $encServer = $db->escapeLike( $wgServer );
  11         $q="DELETE /* deleteSelfExternals */ FROM externallinks WHERE el_to LIKE '$encServer/%' LIMIT 1000\n";
  12         print "Deleting a batch\n";
  13         $db->query($q);
  14         if (!$db->affectedRows()) exit(0);
  15 }