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.

Create 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 = "...";

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