Dump-cut¶

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

nice -n19 bzcat db.backup-2011-07-15.sql.bz2 \
|nice -n19 awk '
BEGIN{
 search_comment=1;
 search_data=0;
 write_out=1
}
{
 if ((search_comment==0)&&(search_data==1)&&($0 ~ /^COPY /)) {
  write_out=0;
  printf ("\n%s",$2) >"/dev/stderr" 
 }
 if ((search_comment==1)&&($0 ~ /^-- Data for Name: /)) {
  search_data=1;
  search_comment=0;
 };
 if (write_out==1) print $0;
 if ((write_out==0)&&($0 ~ /^\\\.$/)) {
  write_out=1;
  search_data=0;
  search_comment=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

Выкусывание таблиц из дампа¶

pv -petraW blizko.backup-2014-01-30.sql.bz2 | nice -n19 bunzip2 | nice -n19 sed -e -n '/^COPY products (.*) FROM stdin;$/,/^\\.$/p;/^\\.$/q' | nice -n19 gzip -3 > products-2014-01-30_00-51.sql.gz