Project

General

Profile

« Previous | Next » 

Revision 14554

/README.TXT: to back up the vegbiendev databases: don't need to review diff for these as it's always unidirectional

View differences:

trunk/README.TXT
404 404
	to back up the vegbiendev databases:
405 405
		ssh -t vegbiendev.nceas.ucsb.edu exec sudo -u aaronmk -i
406 406
		back up MySQL: # usually few changes, so do this first
407
			live= backups/mysql_snapshot
408
				then review diff, and rerun without `live=`
407
			backups/mysql_snapshot
409 408
			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
410 409
			on local machine:
411 410
			l=1 swap=1 overwrite=1 inplace=1 local_dir=~ sync_remote_subdir=                          subpath=~/Documents/BIEN/var/lib/mysql.bak/                          bin/sync_upload
412 411
		back up Postgres:
413
			live= backups/pg_snapshot
414
				then review diff, and rerun without `live=`
412
			backups/pg_snapshot
415 413
	to synchronize vegbiendev, jupiter, and your local machine:
416 414
		**WARNING**: pay careful attention to all files that will be deleted or
417 415
			overwritten!

Also available in: Unified diff