head	1.4;
access;
symbols
	TIGRIS_1_1_0RC2:1.1
	TIGRIS_1_1_0RC1:1.1
	TIGRIS_1_1:1.1.0.4
	TIGRIS_1_0_8:1.1
	TIGRIS_1_0_8RC3:1.1
	TIGRIS_1_0_8RC2:1.1
	TIGRIS_1_0_8RC1:1.1
	TIGRIS_1_0_7:1.1
	TIGRIS_1_0_7RC3:1.1
	TIGRIS_1_0_7RC2:1.1
	TIGRIS_1_0_7RC1:1.1
	TIGRIS_1_0_6:1.1
	TIGRIS_1_0_6RC5:1.1
	TIGRIS_1_0_6RC4:1.1
	TIGRIS_1_0_6RC3:1.1
	TIGRIS_1_0_6RC2:1.1
	TIGRIS_1_0_6RC1:1.1
	TIGRIS_1_0_5:1.1
	TIGRIS_1_0_5RC6:1.1
	TIGRIS_1_0_5RC5:1.1
	TIGRIS_1_0_5RC4:1.1
	TIGRIS_1_0_5RC3:1.1
	TIGRIS_1_0_5RC2:1.1
	TIGRIS_1_0_5RC1:1.1
	TIGRIS_1_0_4:1.1
	TIGRIS_1_0_3:1.1
	TIGRIS_1_0_2:1.1
	TIGRIS_1_0_1:1.1
	TIGRIS_1_0:1.1.0.6
	TIGRIS_1_0_0:1.1
	TIGRIS_1_0_0_RC1:1.1.0.2;
locks; strict;
comment	@# @;


1.4
date	2001.06.22.23.47.37;	author ms;	state Exp;
branches;
next	1.3;

1.3
date	2001.06.22.20.53.39;	author ms;	state Exp;
branches;
next	1.2;

1.2
date	2001.06.14.21.06.58;	author ms;	state Exp;
branches;
next	1.1;

1.1
date	2001.03.19.18.30.14;	author edk;	state Exp;
branches;
next	;


desc
@@


1.4
log
@added link to t.o
@
text
@Migrating the helm database :

1. Setup a new 1.0 sandbox w/ its own db for testing.
2. Do basic tests to verify sandbox is "working".
3. Drop the new sandboxs db tables. Do not drop the db itself!
 
# get the table names and create SQL from them , requires typing the password in
# two times.
echo 'show tables' | mysql -uroot -p $DATABASE_NAME | 
      perl -ne 'next if /Tables in/;
                s/(.*)/DROP TABLE IF EXISTS $1\;/;
                print'
     | mysql -uroot -p $DATABASE_NAME

4. Use mysqldump to export the tigris db from the classic machine.
   ie: mysqldump -uroot -p tigris > tigris.dump
5. Import tigris.dump into new sandbox .
   ie: cat tigris.dump | mysql -uroot -p
6. Execute "$SANDBOX/helm/scripts/upgrade_tigris classic 1.0.0" 
   which alters tables.

====================================================================
Setting up the project homepages:
1. Backup the new sandbox htdoc dir
   ie: mv $SANDBOX/data/helm/htdoc $SANDBOX/data/helm/htdoc.old
2. Copy the data from the old $SANDBOX/html to the new $SANDBOX/data/helm/htdoc.
3. mv $SANDBOX/data/helm/htdoc.old/look $SANDBOX/data/helm/htdoc
4. Lastly, tell the databases that these projects have their own homepages.

$SANDBOX/data/helm/htdoc -name index.html -maxdepth 3 | 
  perl -ne 's,$ENV{SANDBOX}/data/helm/htdoc/([^/]+).*,
            update HELM_PROJECT set USE_INDEX = "Y" where NAME = "$1" ;, ;
            push @@SQL, $_;
            END { print "@@SQL" }  ' | 
  mysql -u$DATABASE_USER -p$DATABASE_PASSWORD $DATABASE_NAME

====================================================================
Setting up mailing lists and archives:
<edk> Place the contents of the old ~tigrisq (/usr/local/tigris/data/helm/qmail
 on the classic instanciation) in /usr/local/tigris/data/helm/qmail-old


====================================================================
see also: http://helm.tigris.org/migration/
@


1.3
log
@added process to setup project homepages. reformmated data in general too
@
text
@d42 3
@


1.2
log
@added more detailed instructions
@
text
@d1 1
a1 1
For the helm database (copied from IRC):
d19 2
a20 1
6. Execute upgrade_tigris which alters tables.
d22 7
d30 9
a40 1

@


1.1
log
@call move_tigrisq, and provide a README with instructions as to how to
do this migration.
@
text
@d3 17
a19 4
<jr> 1. set up a new 1.0 install w/ its own db
<jr> 2. drop that db
<jr> 3. import the one from the old system
<jr> 4. upgrade via upgrade_tigris
a20 1
For anzu's data directory -- after the 1.0 install:
@

