Difference between revisions of "Updating"

From Anarchaserver
Line 59: Line 59:
Backup mysql databases
Backup mysql databases


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




Copy databases locally
Copy databases locally
 
rsync -ah --progress -R (url):/home/(folder)
<code>rsync -ah --progress -R (url):/home/(folder) </code>
 


Copy web folder /var/www
Copy web folder /var/www
 
rsync -ah --progress -R (url):/var/www
<code>rsync -ah --progress -R (url):/var/www </code>
 




Line 81: Line 75:




-UPDATE
== UPDATE multi site WP (+/- old) ==


Updating the networked sites of Wordpress could be done by the graphical user interface (sftp) or via the commandline.
Updating the networked sites of Wordpress could be done by the graphical user interface (sftp) or via the commandline.

Revision as of 02:03, 3 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 --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


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/