# with drop and create statements
$ zcat event_tables_prod1.sql.gz | sed -n "/^-- Table structure for table \`WEEKLY_EXCEPTION_REPORT\`/,/^-- Table structure for table/p" >
# without drop and create statements
$ zcat event_tables_prod1.sql.gz | sed -n "/^-- Dumping data for table \`WEEKLY_EXCEPTION_REPORT\`/,/^-- Dumping data for table /p" > exceptions_only_prod1.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment