Project

General

Profile

« Previous | Next » 

Revision 13466

/README.TXT: Maintenance: added steps to back up the vegbiendev databases

View differences:

trunk/README.TXT
376 376
			make phppgadmin-Linux
377 377
	regularly, re-run full-database import so that bugs in it don't pile up.
378 378
		it needs to be kept in working order so that it works when it's needed.
379
	to back up the vegbiendev databases:
380
		ssh -t vegbiendev.nceas.ucsb.edu exec sudo -u aaronmk -i
381
		back up MySQL: # usually few changes, so do this first
382
			backups/mysql_snapshot
383
			l=1        overwrite=1 inplace=1 local_dir=/ remote_url="$USER@jupiter:/data/dev/aaronmk/Documents/BIEN/" subpath=/var/lib/mysql.bak/ sudo -E env PATH="$PATH" bin/sync_upload
384
			on local machine:
385
			l=1 swap=1 overwrite=1 inplace=1 local_dir=~ sync_remote_subdir=                          subpath=~/Documents/BIEN/var/lib/mysql.bak/                          bin/sync_upload
386
		back up Postgres:
387
			backups/pg_snapshot
379 388
	to synchronize vegbiendev, jupiter, and your local machine:
380 389
		**WARNING**: pay careful attention to all files that will be deleted or
381 390
			overwritten!

Also available in: Unified diff