Media Wiki Restoration: Difference between revisions
| Line 41: | Line 41: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
= | =Update the Database= | ||
<syntaxhighlight lang='bash'> | <syntaxhighlight lang='bash'> | ||
php maintenance/update.php | php maintenance/update.php | ||
| Line 62: | Line 62: | ||
Done in 2 min 25 s. | Done in 2 min 25 s. | ||
</font> | </font> | ||
=Temporary Database Cleanup= | =Temporary Database Cleanup= | ||
Drop the temporary database and user: | Drop the temporary database and user: | ||
Revision as of 00:09, 31 December 2023
Internal
Overview
This procedure documents restoration of a Media Wiki site instance backed up with the tooling described in Media Wiki Backup Automation. 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.
At this point, the MariaDB instance must contain both the temporary and the production database and database users.
SHOW DATABASES;
SELECT user FROM mysql.user;
Collect the production database user, password and database name from the script output.
Update /opt/brew/var/www/mediawiki-1.39.6/LocalSettings.php with those values:
$wgDBname = "novaordis_wiki";
$wgDBuser = "novaordis_wiki";
$wgDBpassword = "...";
Update the Database
php maintenance/update.php
MediaWiki 1.35.14 Updater Your composer.lock file is up to date with current dependencies! Going to run database updates for novaordis_wiki Depending on the size of your database this may take a while! Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0 ...have ipb_id field in ipblocks table.1 ... el_id 10010 - 10402 of 10402 Done, 24 rows updated, 8 deleted. Purging caches...done. Done in 2 min 25 s.
Temporary Database Cleanup
Drop the temporary database and user:
DROP DATABASE tmp_mediawiki_db;
DROP USER 'tmp_mediawiki_user'@'localhost';
COMMIT;
Post Restoration
TO DEPLETE
DEPLETE and INTEGRATE: Restoring a Wiki into the Same or Newer MediaWiki Version