Project

General

Profile

« Previous | Next » 

Revision 13494

/README.TXT: to back up the vegbiendev databases: added step to review diff before performing backup, in case the backup scripts break and try to synchronize things incorrectly

View differences:

trunk/README.TXT
379 379
	to back up the vegbiendev databases:
380 380
		ssh -t vegbiendev.nceas.ucsb.edu exec sudo -u aaronmk -i
381 381
		back up MySQL: # usually few changes, so do this first
382
			backups/mysql_snapshot
382
			live= backups/mysql_snapshot
383
				then review diff, and rerun without `live=`
383 384
			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 385
			on local machine:
385 386
			l=1 swap=1 overwrite=1 inplace=1 local_dir=~ sync_remote_subdir=                          subpath=~/Documents/BIEN/var/lib/mysql.bak/                          bin/sync_upload
386 387
		back up Postgres:
387
			backups/pg_snapshot
388
			live= backups/pg_snapshot
389
				then review diff, and rerun without `live=`
388 390
	to synchronize vegbiendev, jupiter, and your local machine:
389 391
		**WARNING**: pay careful attention to all files that will be deleted or
390 392
			overwritten!

Also available in: Unified diff