restore single table from mysqldump

It works:

grep -n ‘Table structure’ full_dump.sql

19:– Table structure for table `t1`
40:– Table structure for table `t2`
61:– Table structure for table `t3`

sed -n ‘40,61 p’ full_dump.sql > t2.sql

Leave a Reply

Your email address will not be published. Required fields are marked *