User Tools

Site Tools


$ sed -n -e '/CREATE TABLE.*mytable/,/UNLOCK TABLES/p' mysql.dump > mytable.dump

This will copy in the file mytable.dump what is located between CREATE TABLE mytable and the next CREATE TABLE corresponding to the next table.

You can then adjust the file mytable.dump which contains the structure of the table mytable, and the data (a list of INSERT).

mydump_extract.txt · Keista: 2014/12/03 17:48 vartotojo dalius