Search into a sql dump file (*.sql) to extract an insert statement based on the table and a regexp
npm install mysqldumpfindSearch into a sql dump file (\*.sql) to extract an insert statement based on the table and a regexp.
You can also specify a gz file.
Go into a node project and type the following :
$> npm install -g mysqldumpfind
mysqldumpfind extract id "55200" from table "user" in file "exemple.sql" $ mysqldumpfind exemple.sql user 55200
Exemple
(55200,'admin','rafi.piccolo@gmail.com','raphael','piccolo')