TikiWiki Upgrades

Stage the files

cd /var/www/TikiWiki
wget http://internap.dl.sourceforge.net/sourceforge/tikiwiki/tikiwiki-1.9.8.tar.gz
gunzip -c tikiwiki-1.9.8.tar.gz | tar xf -

Find all the changed or added files

cd /var/www/TikiWiki
gunzip -c tikiwiki-1.9.4.tar.gz | tar xf -
diff -qr stovenour tikiwiki-1.9.4
diff -qr jdock tikiwiki-1.9.4

Move over any changed files

Note that this is the most absurd part of the TikiWiki upgrade process. The developers really should provide a way to maintain these files outside of the main Tiki installation directory. Their recomendation is to simply overwrite the old release tree with the new files. That method likely to accumulate "junk" and leave security holes.
cd /var/www/TikiWiki
cp -p stovenour/lib/wiki-plugins/wikiplugin_maketocbox.php tikiwiki-1.9.8/lib/wiki-plugins/wikiplugin_maketocbox.php
cp -p stovenour/lib/wiki-plugins/wikiplugin_thumbdiv.php tikiwiki-1.9.8/lib/wiki-plugins/wikiplugin_thumbdiv.php
cp -p stovenour/lib/wiki-plugins/wikiplugin_twocolortitlebox.php tikiwiki-1.9.8/lib/wiki-plugins/wikiplugin_twocolortitlebox.php
cp -p stovenour/styles/tikipedia.css tikiwiki-1.9.8/styles/tikipedia.css
cp -rp stovenour/styles/tikipedia tikiwiki-1.9.8/styles/tikipedia
cp -rp stovenour/templates/styles/tikipedia tikiwiki-1.9.8/templates/styles/tikipedia

Reinstall any custom Themes

This is the safe way since the themes might need to be updated for the newer release. In my case the tikipedia theme was not updated so I just copied the files out of the old directory in the instructions above. Make sure to also move over any site logos or other custom images. Mine are in the tikipedia theme subdirectory.

Set the file permissions for Debian

cd /var/www/TikiWiki/tikiwiki-1.9.8
chmod u+x ./fixperms.sh
./fixperms.sh fix

Shutdown TikiWiki

/etc/init.d/apache2 stop

Backup the TikiWiki database

cd /var/www/TikiWiki
mysqldump -uroot -p stovenour > stovenour.1.9.4.sql
mysqldump -uroot -p jdock > jdock.1.9.4.sql

Make the directory swap

cd /var/www/TikiWiki
mv stovenour stovenour.1.9.4
mv jdock jdock.1.9.4
cp -rp tikiwiki-1.9.8 stovenour
cp -rp tikiwiki-1.9.8 jdock
cp -p stovenour.1.9.4/db/local.php stovenour/db/local.php
cp -p jdock.1.9.4/db/local.php jdock/db/local.php

Restart TikiWiki

/etc/init.d/apache2 start

Run the database upgrade

http://www.stovenour.net/tiki-install.php
http://www.jdock.org/tiki-install.php
Select the upgrade using the 1.8to1.9 script. There will be lots of failed updates but that is because most of the tables are already correct. When finished disable the tiki-install.php file with the link at the bottom.

Clean up

rm -rf tikiwiki-1.9.4
rm -rf tikiwiki-1.9.8
tar cf - stovenour.1.9.4 stovenour.1.9.4.sql | gzip > stovenour.1.9.4_backup.tar.gz
tar cf - jdock.1.9.4 jdock.1.9.4.sql | gzip > jdock.1.9.4_backup.tar.gz
rm -rf stovenour.1.9.4 stovenour.1.9.4.sql
rm -rf jdock.1.9.4 jdock.1.9.4.sql