User Tools

Site Tools


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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki