Updating

How to keep things up to date in Our Living Sites?! Before updating! BACKUP!

Update from Mediawiki 1.25 to Mediawiki 1.32

Raw bash_history

mysqladmin -u thf -p drop anarcha
mysqladmin -u thf -p create anarcha
mysql -u thf -p anarcha < /home/anarcha03052018.sql 
cd maintenance/
nano ../LocalSettings.php
# check dbprefix ! set to mw_
php update.php 
systemctl start mysql
mysqlcheck -u thf -p anarcha --auto-repair
mysqlcheck -u thf -p anarcha --check
mysqlcheck -u thf -p anarcha --optimize
mysqlcheck -u thf -p anarcha --databases
mysql_upgrade -u root -p
nano LocalSettings.php
wget https://extdist.wmflabs.org/dist/extensions/ConfirmEdit-REL1_32-4a925f4.tar.gz
tar -xzf ConfirmEdit-REL1_32-4a925f4.tar.gz -C /var/www/mediawiki/extensions
nano LocalSettings.php
tail -f /var/log/apache2/alexandria-error.log 
ls -al extensions/
chown -R root:root extensions/ConfirmEdit/
ls -al extensions/
ls -al extensions/ConfirmEdit/ConfirmEdit.alias.php 
nano extensions/ConfirmEdit/ConfirmEdit.alias.php 
nano LocalSettings.php
tail -f /var/log/apache2/alexandria-error.log 
nano LocalSettings.php
apt-get install php-pear
pear install mail
pear install net_smtp
nano LocalSettings.php
cd resources/assets/
wget https://repository.anarchaserver.org/_data/i/upload/2018/09/11/20180911142919-de5107ae-me.png
mv 20180911142919-de5107ae-me.png ada.png
nano LocalSettings.php
nano /var/www/mediawiki/skins/Timeless/resources/libraries/normalise.css
nano /etc/php/7.0/apache2/php.ini  # augment upload and max_post_siez
rm ConfirmEdit-REL1_32-4a925f4.tar.gz 
wget https://gitlab.com/hydrawiki/extensions/EmbedVideo/-/archive/v2.8.0/EmbedVideo-v2.8.0.zip
unzip EmbedVideo-v2.8.0.zip -d extensions/
nano LocalSettings.php
cd extensions/
mv EmbedVideo-v2.8.0/ EmbedVideo/
apt install install imagemagick
apt install imagemagick

• Update Tips (re index db ...) https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup
• Config SMTP https://www.mediawiki.org/wiki/Manual:$wgSMTP

CSS Tuning for Timeless Mediawiki

Possible for 'sysop' users to edit this page and modify the CSS https://alexandria.anarchaserver.org/index.php?title=MediaWiki:Timeless.css&action=edit

Other tunings :

To remove Libertine typo

nano skins/Timeless/resources/variables.less

modify line 41

@fonts: 'Helvetica Neue', 'Nimbus Sans', 'Helvetica', 'Arial', sans-serif;
@fonts-secondary: 'Helvetica Neue', 'Nimbus Sans', 'Helvetica', 'Arial', sans-serif;
//@fonts-secondary: 'Linux Libertine', 'Times New Roman', serif;

BACKUP a mysql database

Backup mysql databases

sudo mysql -u root
mysql> show databases;
sudo mysqldump (name-database) -u root -p (password) > database.sql

Copy databases locally

rsync -ah --progress -R (url):/home/(folder)

Copy web folder /var/www

rsync -ah --progress -R (url):/var/www

Export Wordpress by the webinterface