SAC:Migration Commands

From OSGeo
Revision as of 11:34, 7 June 2010 by Wiki-Crschmidt (talk | contribs) (Created page with 'stash of commands I'm using in the migration. osgeo1: $ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done $ cd .. $ zip -9r db.zip trac-db $ scp db.zip tracsvn…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

stash of commands I'm using in the migration.

osgeo1:

$ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done $ cd .. $ zip -9r db.zip trac-db $ scp db.zip tracsvn.osgeo.osuosl.org

tracsvn:

$ unzip db.zip $ cd trac-db $ time for i in `cat tracs`; do dropdb $i; createdb $i; psql -f $i.dump $i; done


$ rsync -rav trac root@tracsvn.osgeo.osuosl.org:/var/www/