mysql - Extract specific data from full mysqldump backup -

i making regular backups of mysql database mysqldump. gives me .sql file create table , insert statements, allowing me restore database on demand. however, have yet find way extract specific data backup, e.g. extract rows table matching conditions.

thus, current approach restore entire file new temporary database, extract data want new mysqldump call, delete temporary database , import extracted lines real database.

is best way this? there sort of script can directly parse .sql file , extract relevant lines? don't think there easy solution grep , friends unfortunately, mysqldump generates insert statements insert many values per line.

the solution ended being import whole file, extract data needed , drop database again.