[SOLVED] Remove insert data of a specific table from mysqldump output (sed?)

Issue

I have a huge mysqldump output and want to exclude the inserts for a specific table.

The file looks like this:

--
-- Dumping data for table `big_table`
--

INSERT INTO `big_table` ...
INSERT INTO `big_table` ...


--
-- Table structure for table `next_table`
--

How can I cut out those inserts that come between "Dumping data for table big_table" and the next "Table structure for table" The file is too large to fit in a text editor.

Solution

I overlooked the fact that all the inserts of course start with the table name. So I can simply use

grep -v "INSERT INTO \`big_table\`" dump.sql > dump_stripped.sql

Answered By - Alex

Answer Checked By - Cary Denson (WPSolving Admin)