Copy matching lines to a second file

Question

I need to copy all lines in a file matching a pattern to a second file.

In detail: I have a sql dump and want to create a second sql file which includes all commands for tables whose name matches dx_postings, dx_postings_archive, and so on. The pattern should be dx_postings.

Any ideas? I'd prefer an awk or sed solution.

Answer 1

The sed solution:

sed -ne '/pattern/ p' infile >outfile

Answer 2

Ok, see this :

awk '/pattern/' FILE > NEWFILE

more specific :

awk '/^(DROP|LOCK) .*dx_postings/' file.sql > newfile.sql

If you have INSERT or CREATE statements, this is more tricky because there's more than one lines.