Help:Wiki Administration
From YWAMKnowledgeBase
Information this top level is too important for human eyes just now!
Contents |
check databases
mysqlcheck -uroot -p --optimize --all-databases
Optimise and check databases. --repair to repair.
Backup wikidatabase
Assuming your mysql is set up with a root user and assuming your wikidb is called wikidb then
mysqldump -u root -p --opt -v --databases wikidb > wikidb.sql
Will dump the wiki to a file ready for importing. (Wiki sql file is 6 mb as of 6/3/2007)
Importing is done with
mysql wikidb -u root -p -v < wikidb.sql
Migrating to another server and upgrading to MW1.9.1
Upgrading was painless and migrating the sql was not too hard either
STOP! UPGRADE notes in WM 1.9.1 tar ball say this: * May need to upgrade to utf-8 Among other changes, note that Latin-1 encoding (ISO-8859-1) is no longer supported. Latin-1 wikis will need to be upgraded to UTF-8; an experimental command-line upgrade helper script, 'upgrade1_5.php', can do this -- run it prior to 'update.php' or the web upgrader. Also see below Configuration changes
This explained why user white lists was not working! Also $wgNavigationLinks seems not to be working like before! Plus where did the logo go?! This answers it all: [1]
Packages needed:
- mysql, php5, apache mod php5, php5 cli, imagemagick, xpdf (for pdf2text)
- squid
Process:
- stop webserver on old host
- backup db and transfer sql to new host and import
- copy old sskcwiki to new host (could change and change $wgScript to change the prefix as we are going live soon)
- back up Localsettings.php
- copy Adminsettings and add db root and pass
- cp MW 1.9.1 over sskcwiki dir
- permissions 777 over all files
- in maintainance run php update.php and php refreshLinks.php and rebuildImages.php (solves inline images not showing up problem
- remove Adminsettings?
- add to Localsettings.php
$wgAllowExternalImages = true; $wgGroupPermissions['*']['edit'] = false; $wgShowIPinHeader = false; # don't want to see IP when not logged in
- test! and then set up Squid
- Navigation settings: Edit Mediawiki:Sidebar
- Finally change firewall so server points to new server not old
- decomission apache and mysql on old server
- Make sure apache knows it is serving pages to mail.ywambrussels.be or wiki.ywambrussels.be or new domain...
Notes:
- template images are odd - needed to enable $wg images from other sites thingy. It will be all confused until I know exactly what the server name is - but it is not hard to correct
- squid will need setting up again - its refresh needs reducing as users increase to ensure pages reflect current state
- Stats are looking odd! But this corrected itself later...!
Configuration changes from 1.4.x:
$wgDisableUploads has been replaced with $wgEnableUploads.
$wgWhitelistAccount has been replaced by the 'createaccount' permission key in $wgGroupPermissions. To emulate the old effect of setting:
$wgWhitelistAccount['user'] = 0;
set:
$wgGroupPermissions['*']['createaccount'] = false;
$wgWhitelistEdit has been replaced by the 'edit' permission key. To emulate the old effect of setting:
$wgWhitelistEdit = true;
set:
$wgGroupPermissions['*']['edit'] = false;
If $wgWhitelistRead is set, you must also disable the 'read' permission for it to take affect on anonymous users:
$wgWhitelistRead = array( "Main Page", "Special:Userlogin" ); $wgGroupPermissions['*']['read'] = false;
Note that you can disable/enable several other permissions by modifying this configuration array in your LocalSettings.php; see DefaultSettings.php for the complete default permission set.
If using Memcached, you must enabled it differently now:
$wgUseMemCached = true;
should be replaced with:
$wgMainCacheType = CACHE_MEMCACHED;
Customisations made
- All the help files
- All the wiki.png logo
- Brown back ground
- Templates
- wikitable pretty table printing added to the Mediawiki:Common.css page.
To Add:
- Bible extension to replace the template (done)
- Citation extension
- page to pdf extension (done)
