User:Rogerhc/Teflchina upgrade MW 1.16.1 to 1.18.1
Upgrade done on 2012-02-24.
SSH into the server[edit]
ssh rogerchrisman.com cd public_html
Backup files[edit]
tar the teflchina dir but copy it to teflchina.2012-02-24.MW-1.16.1 first so the tar will gracefully unpack later without stepping on existing teflchinaorg dir!
cp -a teflchinaorg teflchinaorg.2012-02-24.MW-1.16.1 tar -czvf teflchinaorg.2012-02-24.MW-1.16.1.tgz teflchinaorg.2012-02-24.MW-1.16.1
Get the new MediaWiki 1.18.1 parts in order[edit]
Get the new MediaWiki files and copy in -a (so datestamps, permissions, etc are preserved) teflchina's
- LocalSettings.php
- images
- .htaccess
- robots.txt
w get http://download.wikimedia.org/mediawiki/1.18/mediawiki-1.18.1.tar.gz ("wget" munged to "w get" in these notes so I can save this page w/o 406) tar -xzvf mediawiki-1.18.1.tar.gz cp -a teflchinaorg/LocalSettings.php mediawiki-1.18.1/. cp -a teflchinaorg/robots.txt mediawiki-1.18.1/. cp -a teflchinaorg/.htaccess mediawiki-1.18.1/. cp -a teflchinaorg/images mediawiki-1.18.1/.
Edit LocalSettings.php to be happy with new MW[edit]
Edit LocalSettings.php so BadBehavior extension is not called (we are using QuestyCaptcha instead), and check for other extensions that we may disable for now, such as DynamicPageList extension (outputs a bulleted list of the most recent items residing in a category, or an intersection of several categories).
cp -a LocalSettings.php LocalSettings.php---2012.02.24.MW-1.16.1 vim LocalSettings.php
Chmod 600 LocalSettings* (if they are not already that way; we do not want others reading our database user password!)
Among other things edited in LocalSettings, note this to got badlogin captcha trigger working (or not, it may only be triggering 5 minute timeout, but I don't know why):
## Shared memory settings #$wgMainCacheType = CACHE_NONE; # Roger 24 Feb 2012 change to CACH_DB so that 'badlogin' would trigger # ConfirmEdit and $wgPasswordAttemptThrottle # See https://forums.dathorn.com/showthread.php?3856-MediaWiki # and http://www.mediawiki.org/wiki/Manual:$wgPasswordAttemptThrottle $wgMainCacheType = CACHE_DB;
Consider merging edited LocalSettings.php into new LocalSettings.php from, say, teflpedia.com where I have a MediaWiki 1.18.1 newly created version of LocalSettings.php. It may be good to do this carefully, later.
P A U S E . . . . . . . H E R E[edit]
This is a good place to take a break
The next part takes the new wiki live
Once we start the next part, we want to finish and comb out bugs
Freeze wiki[edit]
Set wiki read only in LocalSettings
Check that no images have been uploaded since we got images dir above (and get it again now if they have)
Backup database[edit]
To backup the database we dump it into a .sql file and give that a helpful name:
mysqldump -p -u roger -h localhost tcdb > roger_tcdb.2012-02-24.MW-1.16.1.sql
roger_tcdb.2012-02-24.MW-1.16.1.sql is the database backup.
To restore to this backup, if necessary we could do:
mysql -p -u roger -h localhost roger_tcdb < roger_tcdb.2012-02-24.MW-1.16.1.sql
(where "localhost" is the MySQL host, database user is "roger" and "roger_tcdb" is the database name and "roger_tcdb.2012-02-24.MW-1.16.1.sql" the backup we want to replace it with)
Updated that database to MediaWiki 1.18.1 compatibility[edit]
~/public_html/teflchinaorg/maintenance]# php update.php