Difference between revisions of "Updating"

From Anarchaserver
Line 16: Line 16:
mysqlcheck -u thf -p anarcha --auto-repair
mysqlcheck -u thf -p anarcha --auto-repair
mysqlcheck -u thf -p anarcha --check
mysqlcheck -u thf -p anarcha --check
mysqlcheck -u thf -p anarcha --optimize
mysqlcheck -u thf -p anarcha --databases
mysqlcheck -u thf -p anarcha --databases
nano LocalSettings.php
nano LocalSettings.php
Line 64: Line 65:
  @fonts-secondary: '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;
  //@fonts-secondary: 'Linux Libertine', 'Times New Roman', serif;


= BACKUP =
= BACKUP =

Revision as of 23:14, 5 May 2019

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
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

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

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


UPDATE multi site WP (+/- old)

Updating the networked sites of Wordpress could be done by the graphical user interface (sftp) or via the commandline. (the virtual machine) access? Activating ssh by sftp (ssl) means granting 'user' access to root folder to change directories.

Sftp: https://devtidbits.com/2011/06/29/implement-a-sftp-service-for-ubuntudebian-with-a-chrooted-isolated-file-directory/