Difference between revisions of "SAC:Migration Commands"
Jump to navigation
Jump to search
m (trac -> mediawiki) |
|||
| Line 2: | Line 2: | ||
osgeo1: | osgeo1: | ||
| − | + | ||
| − | $ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done | + | $ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done |
| − | $ cd .. | + | $ cd .. |
| − | $ zip -9r db.zip trac-db | + | $ zip -9r db.zip trac-db |
| − | $ scp db.zip tracsvn.osgeo.osuosl.org | + | $ scp db.zip tracsvn.osgeo.osuosl.org |
| − | + | ||
tracsvn: | tracsvn: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | $ rsync -rav trac root@tracsvn.osgeo.osuosl.org:/var/www/ | + | $ 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/ | ||
| + | |||
| + | [[Category:Infrastructure]] | ||
Latest revision as of 14:26, 8 June 2010
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/