Media Wiki Restoration

Internal

• Media Wiki Operations

Overview

This procedure documents restoration of a site instance backed up with the Media Wiki Backup procedure. Restoration implies performing a full new installation of the latest LTS version as a prerequisite, as described here Media Wiki Installation and then executing the database restoration script.

Restore the Database

Use the restoration script to create the database and the database user being restored, then restore the database.

backup-system/mediawiki-restore -v \
  /Users/ovidiu/tmp/2023.12.29-03.00.01-not500-kb.novaordis.com-backup.tgz \
  /opt/brew/var/www/mediawiki-1.39.6 -d /Users/ovidiu/tmp/post-install

Modify the script to be able to stop after restoring the database.

Collect database user, password and database name.

Update /opt/brew/var/www/mediawiki-1.39.6/LocalSettings.php:

$wgDBname = "novaordis_wiki";
$wgDBuser = "novaordis_wiki";
$wgDBpassword = "...";

Upgrade the Database

php maintenance/update.php

Post Restoration

Database Cleanup

Drop the temporary database and user:

DROP DATABASE tmp_mediawiki_db;
DROP USER 'tmp_mediawiki_user'@'localhost';
COMMIT;

TO DEPLETE

DEPLETE and INTEGRATE: Restoring a Wiki into the Same or Newer MediaWiki Version