Posts Tagged ‘restore’

postgress dump restore

pg_dumpall > db.out
psql -f db.out postgres

Windows MSSQL backup

set DIR_BACKUP=c:\backup
set NAME_PC=dbname

md %DIR_BACKUP%

set db_name=master
osql -S %NAME_PC% -E -Q “BACKUP DATABASE %db_name% TO DISK = ‘%DIR_BACKUP%\%db_name%.bak’ with init”

Резервне відновлення з копії

Freebsd dd restore
#echo -e "open host \n \n user <user>,<pass>
\n cd backup/ \n get dd.iso.gz \"|gzip -cd |dd of=/dev/ad0s1"| ftp

Alternative Freebsd dd restore
#echo "get dd2.iso.gz \"|gzip -cd | dd of=/dev/ad0s3\"" | ftp -i ftp://<user>:<pass>@193.111.8.206/backup/
(more…)