Media Wiki Restoration: Difference between revisions
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]] and then executing the database restoration script. | 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]] and then executing the database restoration script. | ||
=Check Preconditions= | |||
At this point, the new Media Wiki installation procedure should have created a temporary database and database user, defined here: [[Media_Wiki_Installation#Instance_Restoration|Media Wiki Installation | Instance Restoration]]. At the end of the restoration, both the temporary database and the database users will be deleted. Verify that they are indeed created, and they are the only Media Wiki database and database user: | |||
{{Internal|mysql Command Line Client#Connect|Connect to MariaDB}} | |||
<syntaxhighlight lang='sql'> | |||
SHOW DATABASES; | |||
SELECT user FROM mysql.user; | |||
</syntaxhighlight> | |||
=Restore the Database= | =Restore the Database= |
Revision as of 20:25, 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 and then executing the database restoration script.
Check Preconditions
At this point, the new Media Wiki installation procedure should have created a temporary database and database user, defined here: Media Wiki Installation | Instance Restoration. At the end of the restoration, both the temporary database and the database users will be deleted. Verify that they are indeed created, and they are the only Media Wiki database and database user:
SHOW DATABASES;
SELECT user FROM mysql.user;
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