Difference between revisions of "Wikispooks:Site Backup"

From Wikispooks
Jump to navigation Jump to search
(another icon)
(icon width)
Line 13: Line 13:
 
==Content of the 'Backups' directory==
 
==Content of the 'Backups' directory==
 
Publicly downloadable backup files are shown in the '''''Index of/backups''''' box above right. Backup dates are included in the filenames. Those in the form <code>name-latest.zip</code> are copies of the latest <code>name-yyy-mm-dd.zip</code> files.
 
Publicly downloadable backup files are shown in the '''''Index of/backups''''' box above right. Backup dates are included in the filenames. Those in the form <code>name-latest.zip</code> are copies of the latest <code>name-yyy-mm-dd.zip</code> files.
*[[image:file.gif|16px|link=https://wikispooks.com/backups/LSadditions.txt]]<code>LSadditions.txt</code> - Text to add to the end of <code>LocalSettings.php</code>
+
*[[image:file.gif|20px|link=https://wikispooks.com/backups/LSadditions.txt]]<code>LSadditions.txt</code> - Text to add to the end of <code>LocalSettings.php</code>
*[[image:file.gif|16px|link=https://wikispooks.com/backups/Readme.txt]]<code>Readme.txt</code> - a text rendering of this page
+
*[[image:file.gif|20px|link=https://wikispooks.com/backups/Readme.txt]]<code>Readme.txt</code> - a text rendering of this page
*[[image:compressed.gif|16px|link=https://wikispooks.com/backups/files-latest.zip]]<code>files-YYYY-MM-DD.zip</code> - a ZIP file of the site images and files
+
*[[image:compressed.gif|20px|link=https://wikispooks.com/backups/files-latest.zip]]<code>files-YYYY-MM-DD.zip</code> - a ZIP file of the site images and files
*[[image:compressed.gif|16px|link=https://wikispooks.com/backups/ws-latest.zip]]<code>ws-YYYY-MM-DD.zip</code> - a ZIP file of the site database
+
*[[image:compressed.gif|20px|link=https://wikispooks.com/backups/ws-latest.zip]]<code>ws-YYYY-MM-DD.zip</code> - a ZIP file of the site database
*[[image:unknown.gif|16px|link=https://wikispooks.com/backups/ws.sql]]<code>ws.sql</code> - uncompressed site database
+
*[[image:unknown.gif|20px|link=https://wikispooks.com/backups/ws.sql]]<code>ws.sql</code> - uncompressed site database
  
 
==Overview==
 
==Overview==

Revision as of 15:40, 27 February 2014

SiteBackup.png

Even if you are a casual reader and not a contributor to this project, you are encouraged to download and keep a backup copy of the site database (~250 MB) and it's associated files and images (~2.3 GB) in case of technical or other problems. Backups of the full Mediawiki software suite (~50 Mb), as configured for the site, are also available.

Backups are published weekly to ensure that, should the site become unavailable for any reason, the information will not be lost - many people around the world will have a reasonably up to date version. The site is open licenced so you are free to copy the information and publish it elsewhere, either as an exact mirror or as part of another website.

Content of the 'Backups' directory

Publicly downloadable backup files are shown in the Index of/backups box above right. Backup dates are included in the filenames. Those in the form name-latest.zip are copies of the latest name-yyy-mm-dd.zip files.

  • File.gifLSadditions.txt - Text to add to the end of LocalSettings.php
  • File.gifReadme.txt - a text rendering of this page
  • Compressed.giffiles-YYYY-MM-DD.zip - a ZIP file of the site images and files
  • Compressed.gifws-YYYY-MM-DD.zip - a ZIP file of the site database
  • Unknown.gifws.sql - uncompressed site database

Overview

To host Wikispooks on your machine, you will need:

  • Some knowledge of running a webserver
  • Some knowledge of the Mediawiki software
  • A site-backup set - The necessary backup files are listed above and here.
  • A computer with at least 5 Gb of free disk space that runs a web server, including
    • PHP v 5.3.2 +
    • MySQL v 5.0.2 +

N.B. Either WampServer or Xampp provides the web-server software you need to run the Wikispooks site locally.

Setting up and running a Copy Of The Site

The backups enable you to import all the files, images and text-content of the site into 'Mediawiki'. Your first task is therefore to install Mediawiki and some mandatory Mediawiki extensions. A list of ALL installed site extensions is shown here. Many of them are mandatory for the site to work properly.

Mandatory extensions

A list of mandatory extensions in approximate order of importance for a functional and presentable site:

  • Semantic MediaWiki - NB: The site will not display ANY pages without this extension.
  • Semantic Forms
  • Semantic Result Formats
  • ParserFunctions
  • Cite
  • Poem
  • Widgets
  • Gadgets
  • CategoryTree
  • No title
  • MagicNoCache
  • MiniMp3
  • SubString and StrLen

Note A few mandatory extensions are not listed above because they are included with a standard installation of one or more of those that are mentioned.

The 'LocalSettings.php' file

Successful installation of the Mediawiki software requires that you download an install-generated file called "LocalSettimgs.php", and put it into the Mediawiki root directory - usually /serverRoot/w/. The file is editable with any plain-text editor. The end of the file will contain the following text:

# End of automatically generated settings.
# Add more configuration options below.

The wikispooks site requires a number of custom configuration parameters, most notably to define new namespaces, extension statements, and permissions. The easiest way for you to include everything necessary is to copy/paste the contents of "LSadditions.txt" to the end of the auto-generated part of the file. However, note that "LSadditions.txt" includes ALL the wikispooks installed extension statements so, if you don't install ALL of them too, you may get errors reported. These can be dealt with by commenting out the corresponding extension statements.

Both the Mediawiki and extensions software, together with comprehensive installation instructions are available from here

Error reporting

If things don't go smoothly, adding the following lines to LocalSettings.php will give you some diagnostic output:

$wgShowExceptionDetails = true;
$wgShowSQLErrors = 1;

It's recommended to take these lines out once things are working OK.

Getting the wikispooks site files, images and content into Mediawiki

Once you have a working installation of Mediawiki, proceed as follows:

  • Unzip "sqldump-latest.zip" in a convenient directory. This will will generate a file named "ws.sql"
  • Unzip "files-latest.zip" in the web server root directory. This will generate many directories and files in and under the web server root.
  • Import the ws.sql database dump into the new database.
    • N.B. The file is too large for a default configuration of phpMyAdmin to handle. Try a MySQL command for this, e.g.
$ mysql -u username -p password -h localhost data-base-name < ws.sql

Finishing Touches

The procedure as explained above is sufficient for the database and all the files. There will be a number of Apache config parameters that need setting in order for 'pretty URLs' to work properly, such as a .htaccess file. Full details can be found on the Mediawiki web site.

Running A Live Site Mirror

If you have interest and resources to set up a realtime site mirror on your server, you are encouraged to do so. We may also be able to provide you with some technical assistance if needed. Requests for help setting up realtime mirrors should be addressed to admin[at]wikispooks.org and encrypted with this key.

Notes

The following items are not included in the backup:

Known Issues

  • Many of the in-text links (especially on 'Category:IFrame' pages) will take you to the master Wikispooks site. This is because urls which ought to be coded as relative, have in fact been entered as absolute urls. It is easy to manually change any such url's in your browser address-bar at run time (simply replace 'https://wikispooks.com/' with 'localhost/your_root_dir_name/'. This issue will be addressed at source as and when.
  • Suggestions, Queries etc? - Either Email the admin (non-WikiSpooks members) or use this discussion page (WikiSpooks members)