MySQL - Restore a specific table from a SQL dump file

Use “table1” as the example table to restore into “database1” from a mylargedump.sql dump file.

grep 'INSERT INTO table1' mylargedump.sql | mysql database1

That’s it! The insert statements for this specific table will pipe directly into MySQL.