Restoring mediawiki to another server - Revision history

Ch at 13:50, 21 December 2025

2025-12-21T13:50:57Z

← Older revision		Revision as of 13:50, 21 December 2025
Line 85:		Line 85:
	::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz \| mysql bradnor</tt>		::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz \| mysql bradnor</tt>
	:::or, better when using ssh - nohup runs process even if ssh session ends		:::or, better when using ssh - nohup runs process even if ssh session ends
	::::<tt>$ sudo gunzip <path to backup> > <unpacked file>		::::<tt>$ sudo gunzip --keep <path to backup> > <unpacked file>
	:::::e.g. sudo gunzip bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql		:::::e.g. sudo gunzip --keep bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql
	::::$ sudo nohup mysql <database name> -e "source <unpacked file>" &		::::$ sudo nohup mysql <database name> -e "source <unpacked file>" &
	:::::e.g. sudo nohup mysql bradnor -e "source bradnor.sql" &		:::::e.g. sudo nohup mysql bradnor -e "source bradnor.sql" &

Ch at 13:44, 21 December 2025

2025-12-21T13:44:24Z

← Older revision		Revision as of 13:44, 21 December 2025
Line 86:		Line 86:
	:::or, better when using ssh - nohup runs process even if ssh session ends		:::or, better when using ssh - nohup runs process even if ssh session ends
	::::<tt>$ sudo gunzip <path to backup> > <unpacked file>		::::<tt>$ sudo gunzip <path to backup> > <unpacked file>
	:::::e.g. sudo ~~cat~~ bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql		:::::e.g. sudo gunzip bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql
	::::$ sudo nohup mysql <database name> -e "source <unpacked file>" &		::::$ sudo nohup mysql <database name> -e "source <unpacked file>" &
	:::::e.g. sudo nohup mysql bradnor -e "source bradnor.sql" &		:::::e.g. sudo nohup mysql bradnor -e "source bradnor.sql" &

Ch at 13:43, 21 December 2025

2025-12-21T13:43:55Z

← Older revision		Revision as of 13:43, 21 December 2025
Line 85:		Line 85:
	::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz \| mysql bradnor</tt>		::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz \| mysql bradnor</tt>
	:::or, better when using ssh - nohup runs process even if ssh session ends		:::or, better when using ssh - nohup runs process even if ssh session ends
	::::<tt>$ sudo ~~cat~~ <path to backup> > <unpacked file>		::::<tt>$ sudo gunzip <path to backup> > <unpacked file>
	:::::e.g. sudo cat bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql		:::::e.g. sudo cat bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql
	::::$ sudo nohup mysql <database name> -e "source <unpacked file>" &		::::$ sudo nohup mysql <database name> -e "source <unpacked file>" &

Ch at 13:19, 17 April 2025

2025-04-17T13:19:57Z

← Older revision		Revision as of 13:19, 17 April 2025
Line 84:		Line 84:
	::::<tt>$ su		::::<tt>$ su
	::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz \| mysql bradnor</tt>		::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz \| mysql bradnor</tt>
			:::or, better when using ssh - nohup runs process even if ssh session ends
			::::<tt>$ sudo cat <path to backup> > <unpacked file>
			:::::e.g. sudo cat bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql
			::::$ sudo nohup mysql <database name> -e "source <unpacked file>" &
			:::::e.g. sudo nohup mysql bradnor -e "source bradnor.sql" &
	:restore files		:restore files
	::restore the <tt>mediawiki/images</tt> directory and set ownership to user <tt>www-data</tt>		::restore the <tt>mediawiki/images</tt> directory and set ownership to user <tt>www-data</tt>

Ch at 15:29, 18 December 2021

2021-12-18T15:29:06Z

New page

[[Notes|⇐ Notes]]

;Install mediawiki
#Install mysql (or MariaDB)
#Install mediawiki
##Follow security instructions about ACLs and file ownership [[https://www.mediawiki.org/wiki/Manual:Security https://www.mediawiki.org/wiki/Manual:Security]]
#Set up TLS (using Certbot) <small>[[https://certbot.eff.org/lets-encrypt/debianbuster-apache https://certbot.eff.org/lets-encrypt/debianbuster-apache]]</small>
##<tt>ssh</tt> into server
##Install certbot software <tt>$ sudo apt-get install certbot python-certbot-apache</tt>
##Allow script to install and configure apache <tt>$ sudo certbot --apache</tt>
## Test automatic renewal with <tt>$ sudo certbot renew --dry-run</tt>
#Set dynamic DNS
##Download the DUC and save the extracted files to: <tt>/usr/local/src</tt> from [[https://my.noip.com/#!/dynamic-dns/duc https://my.noip.com/#!/dynamic-dns/duc]]
##<tt>$ sudo cd /usr/local/src/noip-2.1.9.1</tt>
##<tt>$ make</tt>
##<tt>$ make install</tt>
##Create the configuration file (may have been done by previous step: <tt>$ /usr/local/bin/noip2 -C</tt> You will be prompted to enter your username and password for No-IP, and for the hostnames you wish to update.
##Launch the DUC: <tt>$ /usr/local/bin/noip2</tt>
##Enable at start up (e.g. script in <tt>/etc/initd</tt>)

;Configure mediawiki
:Ensure same extensions etc are installed (see ''Version'' on ''Special pages'')
:::{| class="wikitable"
! Product !! Version
|-
| MediaWiki || 1.31.4
|-
| PHP || 7.3.11-1~deb10u1 (apache2handler)
|-
| MariaDB || 10.0.28-MariaDB-2+b1
|-
| ICU || 63.1
|}

:::{| class="wikitable"
! Extension !! Version !! Licence
|-
| ''Special pages'' || ||
|-
| UserMerge || 1.10.1 (86f0e02)19:29, 3 January 2019 || GPL-2.0-or-later
|-
| || ||
|-
| ''Editors'' || ||
|-
| CodeEditor || – || GPL-2.0-or-later AND BSD-3-Clause
|-
| WikiEditor || 0.5.1 || GPL-2.0-or-later
|-
| || ||
|-
| ''Parser hooks'' || ||
|-
| PDFEmbed || 2.0.2 || LGPL-3.0-only
|-
| || ||
|-
| ''Media handlers'' || ||
|-
| PDF Handler || – || GPL-2.0-or-later
|}
:::for CodeEditor and WikiEditor
::::these extensions are installed by default and only need enabling and configuring in <tt>LocalSettings.php</tt>
:::for PDFHandler, though installed by default, also needs supporting software to install.
::::<tt>sudo apt-get install imagemagick</tt>
::::<tt>sudo apt-get install pdf-utils</tt>
:::::Can check install by
::::<tt>which gs convert pdfinfo pdftotext</tt>
:::for UserMerge and PDFEmbed
::::ensure extensions are installed in <tt>/var/lib/mediawiki/extensions</tt>

;LocalSettings.php
:note that the LocalSettings.php file may refer to other files that also need transferring
::Some parts may have been move to a more secure place, e.g. db and smtp settings
::wiki logo file needs to be copied

;Restore mediawiki
:restore database
::'''''Note: the backup has database name hardcoded and so needs editing if database to be restored to different name'''''
::run as root
::::<tt>$ gunzip < <path to backup>/<backup e.g. my_wiki_week.18.2016-05-07_15h32m.sql.gz> | mysql my_wiki</tt>
:::or, e.g.
::::<tt>$ su
::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz | mysql bradnor</tt>
:restore files
::restore the <tt>mediawiki/images</tt> directory and set ownership to user <tt>www-data</tt>
:::<tt>$ sudo rsync -aHv /rpbackups/rsync/RP1/var/lib/mediawiki-1.36.2/images /var/lib/mediawiki</tt>
:::<tt>$ sudo chown -R www-data:www-data /var/lib/mediawiki/images</tt>
:::<tt>$ sudo chmod -R go-w /var/lib/mediawiki</tt>