Dump-cut¶

Перобразование дампа в схему:

nice -n19 bzcat db.backup-2011-07-15.sql.bz2 |nice -n19 awk 'BEGIN{sc=1;sd=0;wr=1}{if ((sc==0)&&(sd==1)&&($0 ~ /^COPY /)) {wr=0; printf ("\n%s",$2) >"/dev/stderr"}; if ((sc==1)&&($0 ~ /^-- Data for Name: /)) {sd=1; sc=0;}; if (wr==1) print $0; if ((wr==0)&&($0 ~ /^\\\.$/)) {wr=1; sd=0; sc=1}; if (NR%1000==0) printf "." > "/dev/stderr"}END{printf "\nDONE\n" > "/dev/stderr"}' |nice -n19 bzip2 -9 > db-cut.backup-2011-07-15-schema.sql.bz2