Sysadmin:Sysadmin Info

To Do

• Write instructions for backing up database via ssh into [root]/jfa/backups/db with date suffix "-yyyy-mm-dd". See below howtos.
• Write and install cron job to backup database daily into [root]/jfa/backups/db with date suffix "-yyyy-mm-dd".
• Setup cache, use memcache? $wgMainCacheType =
• Setup email on jfawiki provisional production.

Migration Notes

• When migrating, do a search replace on the "https://whatever.xyz" part of the name, and change appropriately. The sidebar in particular will likely have absolute URLs because URLs with a "&" will not work in the sidebar if they are relative.

Handy Links

• Webfaction Failover https://blog.gingerlime.com/2012/webfaction-fail-over/

How To

SSH

>ssh username@web542.webfaction.com >cd /home/gregfuller/webapps/jfawiki/ (for wiki.justiceforanimals.org)

Dump XML pages

>cd /home/gregfuller/webapps/jfawiki/maintenance >php72 dumpBackup.php --current >/home/gregfuller/webapps/jfawiki/jfa/backups/xml/jfawikidump-yyyy-mm-dd.xml FTP the file down to localhost

Database Backup and Restore

Backup Dababase into [root]/jfa/backups/db

Use mysqldump to back up the database. Do not use phpMyAdmin to backup the database

Change directory to jfa/backups/db so the dump will go into this directory, or change the command below

mysqldump -h localhost -u dbuser -p --default-character-set=binary dbname > dbname-mysqldump-YYYY-MM-DD.sql

For production

dbname is jfawiki and the user is jfawiki.

For dev

dbname is djfawiki and the user is djfawiki

See this: https://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki

Preparing the Database Dump for import

If you do not do this step before importing, you will get

"ERROR 1227 (42000) at line 1909: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

You must remove the "DEFINER=" statement from the dump—each entire line. You can do this with a text editor, or with a sed:

sed 's/\sDEFINER=`[^`]*`@`[^`]*`//g' -i oldfile.sql

This is untried, and comes from here: https://stackoverflow.com/questions/44015692/access-denied-you-need-at-least-one-of-the-super-privileges-for-this-operat

Restoring or Migrating a Database

Use a dump created and prepared according to the above entries.

mysql -u dbuser -p dbname < dbnameFromDump-mysqldump-YYYY-MM-DD.sql

See this: https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup

Configure the Parsoid Server for the Visual Editor

Place this in the LocalSettings.php file:

$wgVirtualRestConfig['modules']['parsoid'] = array (
   'url' => 'http://server3.mywikis.net:8142',
);

Move [root]/jfa/backups offsite

ToDo

Include js and css files in a MediaWiki App

• https://www.mediawiki.org/wiki/Snippets/Load_an_additional_JavaScript_or_stylesheet_file_on_all_pages

• done because login page on Refreshed theme doesn't load common.css and common.js

• • https://phabricator.wikimedia.org/project/view/1956/