User:TerryE/phpBB3.0.4 Migration/Detailed Implementation Notes

Detailed Implementation Notes

usOOo server scripts

This script is used to unload the current database

# Dump language schema to TGZ tarball. 
#
# We only have postgres utils v8.1 on the server so wildcards in the pg_dump -t option don't work.
# I will add a case selection to limit the table list for the incremental delta dumps
#
 dump_lang() {
  psql="psql -U ooo_oucv_admin $2"
  tables="`echo \"\d\" | $psql | perl -ne \"/(\w+_${1}_\w+)\s+\| table/ && print \\\$1.' ';\"`"
  for t in $tables; do
    pg_dump -i -U ooo_oucv_admin -x -t $t  -a $2 2> /dev/null
  done
}
# Note that for security reasons these tarballs are deleted after transfer 
backDir=/opt/coolstack/apache2/htdocs/backups
for co in en es fr hu ja vi ; do 
  dump_lang $co en | gzip -c > $backDir/$co.sql.tgz
done
dump_lang zh zh | gzip -c > $backDir/zh.sql.tgz

Standard NL configuration

All instances have the same content and essentially symlink everything but the avatars-load, cache and files directories.

forum:
  adm
  avatars-upload
  cache
  common.php -> ../../phpBB-common/common.php
  config.php -> ../../phpBB-common/config.php
  cron.php -> ../../phpBB-common/cron.php
  docs -> ../../phpBB-common/docs
  download
  faq.php -> ../../phpBB-common/faq.php
  files
  images -> ../../phpBB-common/images
  includes -> ../../phpBB-common/includes
  index.php -> ../../phpBB-common/index.php
  install
  language -> ../../phpBB-common/language
  mcp.php -> ../../phpBB-common/mcp.php
  memberlist.php -> ../../phpBB-common/memberlist.php
  posting.php -> ../../phpBB-common/posting.php
  report.php -> ../../phpBB-common/report.php
  search.php -> ../../phpBB-common/search.php
  store
  style.php -> ../../phpBB-common/style.php
  styles -> ../../phpBB-common/styles
  ucp.php -> ../../phpBB-common/ucp.php
  viewforum.php -> ../../phpBB-common/viewforum.php
  viewonline.php -> ../../phpBB-common/viewonline.php
  viewtopic.php -> ../../phpBB-common/viewtopic.php

forum/adm:
  images -> ../../../phpBB-common/adm/images
  index.php -> ../../../phpBB-common/adm/index.php
  style -> ../../../phpBB-common/adm/style
  swatch.php -> ../../../phpBB-common/adm/swatch.php

forum/avatars-upload:
  <instance specific uploaded avatars go here>

forum/cache:
  index.htm -> ../../../phpBB-common/cache/index.htm
    <instance specific generate cache files go here>

forum/download:
  file.php -> ../../../phpBB-common/download/file.php
  index.htm -> ../../../phpBB-common/download/index.htm

forum/files:
  index.htm -> ../../../phpBB-common/files/index.htm
  <instance specific uploaded attachment files go here>