Media Wiki Restoration: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 27: Line 27:
<syntaxhighlight lang='bash'>
<syntaxhighlight lang='bash'>
php maintenance/update.php
php maintenance/update.php
</syntaxhighlight\>
</syntaxhighlight>


=Post Restoration=
=Post Restoration=

Revision as of 03:41, 30 December 2023

Internal

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.

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