Upgrade a wiki
| Upgrade a wiki|
Organic Design procedure
Shell in and change to the wiki's directory in /var/www/wikis.
Put the site down for maintenance by adding $wgSiteDown = true; to it's LocalSettings.php file.
Update wiki symlink to point to the new code-base.
For information on how to do this, see Run a wiki maintenance script
Using XML dumps instead of SQL
For upgrades that involve major unfixable problems it may be necessary to use XML exports instead...
See Robs notes
Illegal mix of collations error
If the wiki has DPL running on it you may have an error similar such as:
- Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_bin,IMPLICIT) for operation 'concat'
This problem can be solved by looping through all the tables and setting their character set to utf8 using the change the character-set of a wiki database procedure. but first you're best to get rid of the database view that DPL uses with drop prefix_dpl_clview, then change the character sets as shown in the procedure, and then put the DPL view back as shown below (from the DPL manual):
CREATE VIEW prefix_dpl_clview AS SELECT IFNULL(cl_from, page_id) AS cl_from, IFNULL(cl_to, '') AS cl_to, cl_sortkey FROM `prefix_page` LEFT OUTER JOIN `prefix_categorylinks` ON page_id=cl_from;