You can extract table names and all the fields use linux command *SED*.
http://www.cyberciti.biz/faq/sed-display-text/
sometime I used sed command to extract single database from multiple
databases dump file.
using sed to extract single database from the dumpfile:
I have the following info in a text file called file.sql
Is there a way to extract table name and all the fields in this table.
Thanks.
Fahim
-- MySQL dump 10.11
--
-- Host: localhostDatabase: ailMel1
-- --
-- Server version 5.0.67
/*!40
