Difference between revisions of "SAC:Migration Commands"
Jump to navigation
Jump to search
(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…') |
m (trac -> mediawiki) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 3: | Line 3: | ||
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: | ||
| − | $ unzip db.zip | + | $ unzip db.zip |
| − | $ cd trac-db | + | $ cd trac-db |
| − | $ time for i in `cat tracs`; do dropdb $i; createdb $i; psql -f $i.dump $i; done | + | $ 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/ | + | $ 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/