[moira.git] / backup / restore_from_backup

#!/bin/csh

set path=(. /bin /usr/bin ~rtingres/bin)

if ($user != smsdba) then
	echo "This script must be run as smsdba"
	exit 1
endif

createdb smstemp
if ($status) then
	echo "unable to create database"
	exit 2
endif

cd /mit/smsdev/backup

ingres smstemp < dodbbuild

smsrestore

ingres smstemp < dodbopt

sysmod smstemp

echo "When you are satisfied that this is correct, rename the smstemp database"
echo "to sms by renaming directories under ~rtingres/data/default, then run"
echo "'finddbs -r' to fix the ingres database database."

exit 0
Commit	Line	Data
3a3bd871	1	#!/bin/csh
	2
	3	set path=(. /bin /usr/bin ~rtingres/bin)
	4
	5	if ($user != smsdba) then
	6	echo "This script must be run as smsdba"
	7	exit 1
	8	endif
	9
	10	createdb smstemp
	11	if ($status) then
	12	echo "unable to create database"
	13	exit 2
	14	endif
	15
	16	cd /mit/smsdev/backup
	17
	18	ingres smstemp < dodbbuild
	19
	20	smsrestore
	21
	22	ingres smstemp < dodbopt
	23
	24	sysmod smstemp
	25
	26	echo "When you are satisfied that this is correct, rename the smstemp database"
	27	echo "to sms by renaming directories under ~rtingres/data/default, then run"
	28	echo "'finddbs -r' to fix the ingres database database."
	29
	30	exit 0