https://stackoverflow.com/questions/13913014/grepping-a-huge-file-80gb-any-way-to-speed-it-up LC_ALL=C fgrep -A 5 -B 5 'db_pd.Clients' eightygigsfile.sql -A 5 -B 5 mean get 5 lines in for example CREATE TABLE `r1_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cat_name` varchar(100) NOT NULL, `caption` varchar(100) NOT NULL, `cat_caption` varchar(100) NOT NULL, `coupon_catid` int(11) DEFAULT NULL, // Trimmed line KEY `cat_name` (`cat_name`,`discount_status`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; => If you want full columns in CREATE query, increase A B parameter: LC_ALL=C fgrep -A 15 -B 15 'db_pd.Clients' eightygigsfile.sql > Client.sql // grep -Fn --text "1-Piston Calipers; Oversized" product_NOV_22.csv // -F for treat input pattern search as fixed string
Some tribes of the programmer clan.