Migrating Mir from one server to another
This documetn describes my experience moving to a Debian Sarge install in May, 2006. First I installed Sarge. Then, I started with these directions:
At step 5, tar up your mir source directory and copy it to your new machine in the /var/www/cms dir. Skip step 6.
on the old machine, dump the old db:
setup env vars with your db login info:
# export PGUSER=bla
# export PGPASSWD=bla
or su to the db user if you have local ident auth only.
# pg_dump -b -F t -d -O -R > outputfile.tar
restore the database on the new machine:
create the new database, with the UNICODE encoding!
# createdb --encoding UNICODE olddbname
su to the postgres user, then run the psql command to get to the shell:
# psql olddbname
then do this command to create your old db user and old db password:
# CREATE USER olduser WITH PASSWORD 'oldpasswd' NOCREATEDB NOCREATEUSER;
edit /etc/pg_hba.conf for the 127.0.0.1 entry to not require ident authentication. Change "ident sameuser" to "md5"
then, run the restore command:
# pg_restore -F t -d
then copy your apache config over.
# /etc/init.d/apache2 restart
# /etc/init.d/tomcat4 restart
I had to then follow the instructions here for properly configuring tomcat and apache2:
and I'm still working out some small issues, so this is a bit incomplete...
- 10 May 2006