Notes describing upgrade from MW-1.6.10 to MW-1.15.1

From AFSWiki

Contents 1 High Level Overview 2 Detailed Procedure 2.1 DNS Redirect 2.2 Database copy 2.3 Directory tree modifications 2.4 Upgrade the database 2.5 DNS Redirect

High Level Overview

• Extensive testing converting the database had already occurred off-line on a test server to assure, at the time of the upgrade on the production server, no occurrence of unanticipated issues.

• Uploads directory, which stores all uploaded (non-wiki text) files, will be left in place.

• Export the current database

• Import into the new database

Note: Originally, the database was created in a separate account. New database has been created under the afswiki account at Pair Networks.

Detailed Procedure

DNS Redirect

• Under the MyPair.com control panel, "Manage Domain Names", "Domain mapping" was mapped to <DOCUMENT ROOT>/mediawiki-1.6.10/ , and cleared out to only <DOCUMENT ROOT>.
  • This change made the wiki inaccessible to visitors while the site was under maintenance (index.html symbolic ~> gonefishin.html)

Database copy

mysqldump -Qq -h db92a.pair.com -u nateg_2 -p nateg_afswiki > backups/db/20091129-backup.sql

• This command exported the old database location to a backup file location

• A slight modification of the database was performed to change the prefix of all table names from 'afs' to 'afs_'. This change improved the readability of the sql table names. This change would be described as a "search and replace" change, with a change to approximately 300 entries in the .SQL file.

mysql -h db135a.pair.com -u afswiki -p afswiki_db < 20091129-merge.sql

• This command imported the modified sql file into the new database location.

Directory tree modifications

• All contents of ../public_html/mediawiki-1.6.10/, except "uploads" and "v115" were deleted.
  • Note: The customizations to LocalSettings.php had already been transferred to the "v115/LocalSettings.php".
• All the contents of ../public_html/mediawiki-1.6.10/v115/ were moved to ../public_html/mediawiki-1.6.10.
• The directory ../public_html/mediawiki-1.6.10/ was renamed to ../public_html/mediawiki-1.15.1/.
• The symblic link ../public_html/wiki was fixed to point to the new MediaWiki directory tree.
• The new LocalSettings.php file was fixed to use the afs_ database table prefix (Reference "slight modification" under Database Copy)

Upgrade the database

php update.php --aconf ../AdminSettings.php

• This command performed the update of MW sql database from version 1.6, and added tables, etc, to be compatible with version 1.15.

DNS Redirect

• Under the MyPair.com control panel, "Manage Domain Names", "Domain mapping" change map to <DOCUMENT ROOT>/wiki
• This change made the wiki again accessible to viewers.