mysql:restore_a_specific_table_from_a_sql_dump_file
This is an old revision of the document!
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.
mysql/restore_a_specific_table_from_a_sql_dump_file.1479724918.txt.gz · Last modified: 2020/07/15 09:30 (external edit)