MediaWiki  master
BackupDumper.php
Go to the documentation of this file.
1 <?php
28 require_once __DIR__ . '/../Maintenance.php';
29 require_once __DIR__ . '/../../includes/export/WikiExporter.php';
30 
34 
39 abstract class BackupDumper extends Maintenance {
40  public $reporting = true;
41  public $pages = null; // all pages
42  public $skipHeader = false; // don't output <mediawiki> and <siteinfo>
43  public $skipFooter = false; // don't output </mediawiki>
44  public $startId = 0;
45  public $endId = 0;
46  public $revStartId = 0;
47  public $revEndId = 0;
48  public $dumpUploads = false;
49  public $dumpUploadFileContents = false;
50  public $orderRevs = false;
51  public $limitNamespaces = [];
53  public $stderr;
54 
55  protected $reportingInterval = 100;
56  protected $pageCount = 0;
57  protected $revCount = 0;
58  protected $schemaVersion = null; // use default
59  protected $server = null; // use default
60  protected $sink = null; // Output filters
61  protected $lastTime = 0;
62  protected $pageCountLast = 0;
63  protected $revCountLast = 0;
64 
65  protected $outputTypes = [];
66  protected $filterTypes = [];
67 
68  protected $ID = 0;
69 
71  protected $startTime;
73  protected $pageCountPart;
75  protected $revCountPart;
77  protected $maxCount;
79  protected $timeOfCheckpoint;
81  protected $egress;
83  protected $buffer;
85  protected $openElement;
87  protected $atStart;
89  protected $thisRevModel;
91  protected $thisRevFormat;
93  protected $lastName;
95  protected $state;
96 
104  protected $forcedDb = null;
105 
107  protected $lb;
108 
112  public function __construct( $args = null ) {
113  parent::__construct();
114  $this->stderr = fopen( "php://stderr", "wt" );
115 
116  // Built-in output and filter plugins
117  $this->registerOutput( 'file', DumpFileOutput::class );
118  $this->registerOutput( 'gzip', DumpGZipOutput::class );
119  $this->registerOutput( 'bzip2', DumpBZip2Output::class );
120  $this->registerOutput( 'dbzip2', DumpDBZip2Output::class );
121  $this->registerOutput( 'lbzip2', DumpLBZip2Output::class );
122  $this->registerOutput( '7zip', Dump7ZipOutput::class );
123 
124  $this->registerFilter( 'latest', DumpLatestFilter::class );
125  $this->registerFilter( 'notalk', DumpNotalkFilter::class );
126  $this->registerFilter( 'namespace', DumpNamespaceFilter::class );
127 
128  // These three can be specified multiple times
129  $this->addOption( 'plugin', 'Load a dump plugin class. Specify as <class>[:<file>].',
130  false, true, false, true );
131  $this->addOption( 'output', 'Begin a filtered output stream; Specify as <type>:<file>. ' .
132  '<type>s: file, gzip, bzip2, 7zip, dbzip2, lbzip2', false, true, 'o', true );
133  $this->addOption( 'filter', 'Add a filter on an output branch. Specify as ' .
134  '<type>[:<options>]. <types>s: latest, notalk, namespace', false, true, false, true );
135  $this->addOption( 'report', 'Report position and speed after every n pages processed. ' .
136  'Default: 100.', false, true );
137  $this->addOption( 'schema-version', 'Schema version to use for output. ' .
138  'Default: ' . WikiExporter::schemaVersion(), false, true );
139  $this->addOption( 'server', 'Force reading from MySQL server', false, true );
140  $this->addOption( '7ziplevel', '7zip compression level for all 7zip outputs. Used for ' .
141  '-mx option to 7za command.', false, true );
142 
143  if ( $args ) {
144  // Args should be loaded and processed so that dump() can be called directly
145  // instead of execute()
146  $this->loadWithArgv( $args );
147  $this->processOptions();
148  }
149  }
150 
155  public function registerOutput( $name, $class ) {
156  $this->outputTypes[$name] = $class;
157  }
158 
163  public function registerFilter( $name, $class ) {
164  $this->filterTypes[$name] = $class;
165  }
166 
174  public function loadPlugin( $class, $file ) {
175  if ( $file != '' ) {
176  require_once $file;
177  }
178  $register = [ $class, 'register' ];
179  $register( $this );
180  }
181 
182  public function execute() {
183  throw new MWException( 'execute() must be overridden in subclasses' );
184  }
185 
189  protected function processOptions() {
190  $sink = null;
191  $sinks = [];
192 
193  $this->schemaVersion = WikiExporter::schemaVersion();
194 
195  $options = $this->orderedOptions;
196  foreach ( $options as [ $opt, $param ] ) {
197  switch ( $opt ) {
198  case 'plugin':
199  $val = explode( ':', $param, 2 );
200 
201  if ( count( $val ) === 1 ) {
202  $this->loadPlugin( $val[0], '' );
203  } elseif ( count( $val ) === 2 ) {
204  $this->loadPlugin( $val[0], $val[1] );
205  }
206 
207  break;
208  case 'output':
209  $split = explode( ':', $param, 2 );
210  if ( count( $split ) !== 2 ) {
211  $this->fatalError( 'Invalid output parameter' );
212  }
213  list( $type, $file ) = $split;
214  if ( $sink !== null ) {
215  $sinks[] = $sink;
216  }
217  if ( !isset( $this->outputTypes[$type] ) ) {
218  $this->fatalError( "Unrecognized output sink type '$type'" );
219  }
220  $class = $this->outputTypes[$type];
221  if ( $type === "7zip" ) {
222  $sink = new $class( $file, intval( $this->getOption( '7ziplevel' ) ) );
223  } else {
224  $sink = new $class( $file );
225  }
226 
227  break;
228  case 'filter':
229  if ( $sink === null ) {
230  $sink = new DumpOutput();
231  }
232 
233  $split = explode( ':', $param, 2 );
234  $key = $split[0];
235 
236  if ( !isset( $this->filterTypes[$key] ) ) {
237  $this->fatalError( "Unrecognized filter type '$key'" );
238  }
239 
240  $type = $this->filterTypes[$key];
241 
242  if ( count( $split ) === 1 ) {
243  $filter = new $type( $sink );
244  } elseif ( count( $split ) === 2 ) {
245  $filter = new $type( $sink, $split[1] );
246  }
247 
248  // references are lame in php...
249  unset( $sink );
250  $sink = $filter;
251 
252  break;
253  case 'schema-version':
254  if ( !in_array( $param, XmlDumpWriter::$supportedSchemas ) ) {
255  $this->fatalError(
256  "Unsupported schema version $param. Supported versions: " .
257  implode( ', ', XmlDumpWriter::$supportedSchemas )
258  );
259  }
260  $this->schemaVersion = $param;
261  break;
262  }
263  }
264 
265  if ( $this->hasOption( 'report' ) ) {
266  $this->reportingInterval = intval( $this->getOption( 'report' ) );
267  }
268 
269  if ( $this->hasOption( 'server' ) ) {
270  $this->server = $this->getOption( 'server' );
271  }
272 
273  if ( $sink === null ) {
274  $sink = new DumpOutput();
275  }
276  $sinks[] = $sink;
277 
278  if ( count( $sinks ) > 1 ) {
279  $this->sink = new DumpMultiWriter( $sinks );
280  } else {
281  $this->sink = $sink;
282  }
283  }
284 
285  public function dump( $history, $text = WikiExporter::TEXT ) {
286  # Notice messages will foul up your XML output even if they're
287  # relatively harmless.
288  if ( ini_get( 'display_errors' ) ) {
289  ini_set( 'display_errors', 'stderr' );
290  }
291 
292  $this->initProgress( $history );
293 
294  $db = $this->backupDb();
295  $services = MediaWikiServices::getInstance();
296  $exporter = $services->getWikiExporterFactory()->getWikiExporter(
297  $db,
298  $history,
299  $text,
300  $this->limitNamespaces
301  );
302  $exporter->setSchemaVersion( $this->schemaVersion );
303  $exporter->dumpUploads = $this->dumpUploads;
304  $exporter->dumpUploadFileContents = $this->dumpUploadFileContents;
305 
306  $wrapper = new ExportProgressFilter( $this->sink, $this );
307  $exporter->setOutputSink( $wrapper );
308 
309  if ( !$this->skipHeader ) {
310  $exporter->openStream();
311  }
312  # Log item dumps: all or by range
313  if ( $history & WikiExporter::LOGS ) {
314  if ( $this->startId || $this->endId ) {
315  $exporter->logsByRange( $this->startId, $this->endId );
316  } else {
317  $exporter->allLogs();
318  }
319  } elseif ( $this->pages === null ) {
320  # Page dumps: all or by page ID range
321  if ( $this->startId || $this->endId ) {
322  $exporter->pagesByRange( $this->startId, $this->endId, $this->orderRevs );
323  } elseif ( $this->revStartId || $this->revEndId ) {
324  $exporter->revsByRange( $this->revStartId, $this->revEndId );
325  } else {
326  $exporter->allPages();
327  }
328  } else {
329  # Dump of specific pages
330  $exporter->pagesByName( $this->pages );
331  }
332 
333  if ( !$this->skipFooter ) {
334  $exporter->closeStream();
335  }
336 
337  $this->report( true );
338  }
339 
346  public function initProgress( $history = WikiExporter::FULL ) {
347  $table = ( $history == WikiExporter::CURRENT ) ? 'page' : 'revision';
348  $field = ( $history == WikiExporter::CURRENT ) ? 'page_id' : 'rev_id';
349 
351  if ( $this->forcedDb === null ) {
352  $dbr = $this->getDB( DB_REPLICA, [ 'dump' ] );
353  }
354  $this->maxCount = $dbr->selectField( $table, "MAX($field)", '', __METHOD__ );
355  $this->startTime = microtime( true );
356  $this->lastTime = $this->startTime;
357  $this->ID = getmypid();
358  }
359 
366  protected function backupDb() {
367  if ( $this->forcedDb !== null ) {
368  return $this->forcedDb;
369  }
370 
371  $lbFactory = MediaWikiServices::getInstance()->getDBLoadBalancerFactory();
372  $this->lb = $lbFactory->newMainLB();
373  $db = $this->lb->getMaintenanceConnectionRef( DB_REPLICA, 'dump' );
374 
375  // Discourage the server from disconnecting us if it takes a long time
376  // to read out the big ol' batch query.
377  $db->setSessionOptions( [ 'connTimeout' => 3600 * 24 ] );
378 
379  return $db;
380  }
381 
388  public function setDB( IMaintainableDatabase $db ) {
389  parent::setDB( $db );
390  $this->forcedDb = $db;
391  }
392 
393  public function __destruct() {
394  if ( isset( $this->lb ) ) {
395  $this->lb->closeAll( __METHOD__ );
396  }
397  }
398 
399  protected function backupServer() {
400  global $wgDBserver;
401 
402  return $this->server ?: $wgDBserver;
403  }
404 
405  public function reportPage() {
406  $this->pageCount++;
407  }
408 
409  public function revCount() {
410  $this->revCount++;
411  $this->report();
412  }
413 
414  public function report( $final = false ) {
415  if ( $final xor ( $this->revCount % $this->reportingInterval == 0 ) ) {
416  $this->showReport();
417  }
418  }
419 
420  public function showReport() {
421  if ( $this->reporting ) {
422  $now = wfTimestamp( TS_DB );
423  $nowts = microtime( true );
424  $deltaAll = $nowts - $this->startTime;
425  $deltaPart = $nowts - $this->lastTime;
426  $this->pageCountPart = $this->pageCount - $this->pageCountLast;
427  $this->revCountPart = $this->revCount - $this->revCountLast;
428 
429  if ( $deltaAll ) {
430  $portion = $this->revCount / $this->maxCount;
431  $eta = $this->startTime + $deltaAll / $portion;
432  $etats = wfTimestamp( TS_DB, intval( $eta ) );
433  $pageRate = $this->pageCount / $deltaAll;
434  $revRate = $this->revCount / $deltaAll;
435  } else {
436  $pageRate = '-';
437  $revRate = '-';
438  $etats = '-';
439  }
440  if ( $deltaPart ) {
441  $pageRatePart = $this->pageCountPart / $deltaPart;
442  $revRatePart = $this->revCountPart / $deltaPart;
443  } else {
444  $pageRatePart = '-';
445  $revRatePart = '-';
446  }
447 
448  $dbDomain = WikiMap::getCurrentWikiDbDomain()->getId();
449  $this->progress( sprintf(
450  "%s: %s (ID %d) %d pages (%0.1f|%0.1f/sec all|curr), "
451  . "%d revs (%0.1f|%0.1f/sec all|curr), ETA %s [max %d]",
452  $now, $dbDomain, $this->ID, $this->pageCount, $pageRate,
453  $pageRatePart, $this->revCount, $revRate, $revRatePart, $etats,
454  $this->maxCount
455  ) );
456  $this->lastTime = $nowts;
457  $this->revCountLast = $this->revCount;
458  }
459  }
460 
461  protected function progress( $string ) {
462  if ( $this->reporting ) {
463  fwrite( $this->stderr, $string . "\n" );
464  }
465  }
466 }
BackupDumper\registerOutput
registerOutput( $name, $class)
Definition: BackupDumper.php:155
BackupDumper\$thisRevFormat
string null $thisRevFormat
Definition: BackupDumper.php:91
WikiExporter\schemaVersion
static schemaVersion()
Returns the default export schema version, as defined by $wgXmlDumpSchemaVersion.
Definition: WikiExporter.php:97
BackupDumper\$endId
$endId
Definition: BackupDumper.php:45
BackupDumper\revCount
revCount()
Definition: BackupDumper.php:409
WikiMap\getCurrentWikiDbDomain
static getCurrentWikiDbDomain()
Definition: WikiMap.php:293
BackupDumper\backupDb
backupDb()
Definition: BackupDumper.php:366
$wgDBserver
$wgDBserver
Database host name or IP address.
Definition: DefaultSettings.php:2085
BackupDumper\$startTime
int $startTime
Definition: BackupDumper.php:71
MediaWiki\MediaWikiServices
MediaWikiServices is the service locator for the application scope of MediaWiki.
Definition: MediaWikiServices.php:195
BackupDumper\$revCountPart
int $revCountPart
Definition: BackupDumper.php:75
Maintenance\fatalError
fatalError( $msg, $exitCode=1)
Output a message and terminate the current script.
Definition: Maintenance.php:489
WikiExporter\CURRENT
const CURRENT
Definition: WikiExporter.php:56
BackupDumper\$revEndId
$revEndId
Definition: BackupDumper.php:47
wfTimestamp
wfTimestamp( $outputtype=TS_UNIX, $ts=0)
Get a timestamp string in one of various formats.
Definition: GlobalFunctions.php:1668
BackupDumper\backupServer
backupServer()
Definition: BackupDumper.php:399
BackupDumper\$limitNamespaces
$limitNamespaces
Definition: BackupDumper.php:51
BackupDumper\$thisRevModel
string null $thisRevModel
Definition: BackupDumper.php:89
BackupDumper\$openElement
array false $openElement
Definition: BackupDumper.php:85
BackupDumper\__destruct
__destruct()
Definition: BackupDumper.php:393
BackupDumper\$revCountLast
$revCountLast
Definition: BackupDumper.php:63
$file
if(PHP_SAPI !='cli-server') if(!isset( $_SERVER['SCRIPT_FILENAME'])) $file
Item class for a filearchive table row.
Definition: router.php:42
BackupDumper\$pageCountLast
$pageCountLast
Definition: BackupDumper.php:62
BackupDumper\$revCount
$revCount
Definition: BackupDumper.php:57
BackupDumper\$sink
$sink
Definition: BackupDumper.php:60
Maintenance
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
Definition: Maintenance.php:59
BackupDumper\$lb
LoadBalancer $lb
Definition: BackupDumper.php:107
XmlDumpWriter\$supportedSchemas
static string[] $supportedSchemas
the schema versions supported for output @final
Definition: XmlDumpWriter.php:57
BackupDumper\$skipFooter
$skipFooter
Definition: BackupDumper.php:43
BackupDumper\$orderRevs
$orderRevs
Definition: BackupDumper.php:50
BackupDumper\$buffer
string $buffer
Definition: BackupDumper.php:83
Maintenance\loadWithArgv
loadWithArgv( $argv)
Load params and arguments from a given array of command-line arguments.
Definition: Maintenance.php:817
$dbr
$dbr
Definition: testCompression.php:54
BackupDumper\$schemaVersion
$schemaVersion
Definition: BackupDumper.php:58
DumpMultiWriter
Definition: DumpMultiWriter.php:29
BackupDumper\$skipHeader
$skipHeader
Definition: BackupDumper.php:42
BackupDumper\$reporting
$reporting
Definition: BackupDumper.php:40
MWException
MediaWiki exception.
Definition: MWException.php:29
BackupDumper\showReport
showReport()
Definition: BackupDumper.php:420
WikiExporter\TEXT
const TEXT
Definition: WikiExporter.php:61
BackupDumper\$startId
$startId
Definition: BackupDumper.php:44
BackupDumper\$maxCount
int $maxCount
Definition: BackupDumper.php:77
Maintenance\addOption
addOption( $name, $description, $required=false, $withArg=false, $shortName=false, $multiOccurrence=false)
Add a parameter to the script.
Definition: Maintenance.php:249
$args
if( $line===false) $args
Definition: mcc.php:124
Maintenance\$orderedOptions
array $orderedOptions
Used to read the options in the order they were passed.
Definition: Maintenance.php:172
BackupDumper\loadPlugin
loadPlugin( $class, $file)
Load a plugin and register it.
Definition: BackupDumper.php:174
BackupDumper\$dumpUploadFileContents
$dumpUploadFileContents
Definition: BackupDumper.php:49
DB_REPLICA
const DB_REPLICA
Definition: defines.php:25
DumpOutput
Definition: DumpOutput.php:29
BackupDumper\$timeOfCheckpoint
int $timeOfCheckpoint
Definition: BackupDumper.php:79
BackupDumper\$ID
$ID
Definition: BackupDumper.php:68
Wikimedia\Rdbms\LoadBalancer
Database connection, tracking, load balancing, and transaction manager for a cluster.
Definition: LoadBalancer.php:43
BackupDumper\initProgress
initProgress( $history=WikiExporter::FULL)
Initialise starting time and maximum revision count.
Definition: BackupDumper.php:346
BackupDumper\$state
string $state
Definition: BackupDumper.php:95
BackupDumper\report
report( $final=false)
Definition: BackupDumper.php:414
BackupDumper\$pageCountPart
int $pageCountPart
Definition: BackupDumper.php:73
BackupDumper\$outputTypes
$outputTypes
Definition: BackupDumper.php:65
BackupDumper\$reportingInterval
$reportingInterval
Definition: BackupDumper.php:55
BackupDumper\$pages
$pages
Definition: BackupDumper.php:41
WikiExporter\FULL
const FULL
Definition: WikiExporter.php:55
BackupDumper\$dumpUploads
$dumpUploads
Definition: BackupDumper.php:48
Maintenance\getDB
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
Definition: Maintenance.php:1362
BackupDumper\__construct
__construct( $args=null)
Definition: BackupDumper.php:112
BackupDumper\$atStart
bool $atStart
Definition: BackupDumper.php:87
BackupDumper\progress
progress( $string)
Definition: BackupDumper.php:461
BackupDumper\$stderr
bool resource $stderr
Definition: BackupDumper.php:53
BackupDumper
Definition: BackupDumper.php:39
BackupDumper\execute
execute()
Do the actual work.
Definition: BackupDumper.php:182
Maintenance\getOption
getOption( $name, $default=null)
Get an option, or return the default.
Definition: Maintenance.php:286
WikiExporter\LOGS
const LOGS
Definition: WikiExporter.php:58
BackupDumper\$server
$server
Definition: BackupDumper.php:59
BackupDumper\reportPage
reportPage()
Definition: BackupDumper.php:405
BackupDumper\processOptions
processOptions()
Processes arguments and sets $this->$sink accordingly.
Definition: BackupDumper.php:189
BackupDumper\$lastTime
$lastTime
Definition: BackupDumper.php:61
BackupDumper\dump
dump( $history, $text=WikiExporter::TEXT)
Definition: BackupDumper.php:285
BackupDumper\$filterTypes
$filterTypes
Definition: BackupDumper.php:66
ExportProgressFilter
Definition: ExportProgressFilter.php:27
Maintenance\hasOption
hasOption( $name)
Checks to see if a particular option was set.
Definition: Maintenance.php:271
Wikimedia\Rdbms\IDatabase\setSessionOptions
setSessionOptions(array $options)
Override database's default behavior.
Wikimedia\Rdbms\IMaintainableDatabase
Advanced database interface for IDatabase handles that include maintenance methods.
Definition: IMaintainableDatabase.php:38
BackupDumper\setDB
setDB(IMaintainableDatabase $db)
Force the dump to use the provided database connection for database operations, wherever possible.
Definition: BackupDumper.php:388
BackupDumper\$forcedDb
IMaintainableDatabase null $forcedDb
The dependency-injected database to use.
Definition: BackupDumper.php:104
BackupDumper\$egress
ExportProgressFilter $egress
Definition: BackupDumper.php:81
BackupDumper\$revStartId
$revStartId
Definition: BackupDumper.php:46
BackupDumper\$pageCount
$pageCount
Definition: BackupDumper.php:56
BackupDumper\$lastName
string $lastName
Definition: BackupDumper.php:93
$type
$type
Definition: testCompression.php:52
BackupDumper\registerFilter
registerFilter( $name, $class)
Definition: BackupDumper.php:163