mysql:restore_a_specific_table_from_a_sql_dump_file
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.txt · Last modified: 2020/07/15 09:30 by 127.0.0.1