====== 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.