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:

http://docs.indymedia.org/view/Devel/MiRInstallDebian

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.

restart apache.

# /etc/init.d/apache2 restart

restart tomcat.

# /etc/init.d/tomcat4 restart

I had to then follow the instructions here for properly configuring tomcat and apache2: http://docs.indymedia.org/view/Sysadmin/TravenMirInstall

and I'm still working out some small issues, so this is a bit incomplete...

-- SdLotus - 10 May 2006