Media Wiki Restoration: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 3: Line 3:
=Overview=
=Overview=
This procedure documents restoration of a site instance backed up with the [[Media_Wiki_Backup#Overview|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#Overview|Media Wiki Installation]].
This procedure documents restoration of a site instance backed up with the [[Media_Wiki_Backup#Overview|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#Overview|Media Wiki Installation]].
=Create the Database=
=Restore the Database=


Use the restoration script to create the database and the database user being restored, then restore the database.
Use the restoration script to create the database and the database user being restored, then restore the database.
Line 24: Line 24:
$wgDBpassword = "...";
$wgDBpassword = "...";
</syntaxhighlight>
</syntaxhighlight>
=Upgrade the Database=


=Post Restoration=
=Post Restoration=

Revision as of 03:40, 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

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