Shell Programming and Scripting

cat onlytables.sql
create table NextID (
        id int auto_increment,
        zoneID int,
        entityName varchar(64),
        nextID int,
        lastModified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        primary key(id)
) engine=Innodb;
.
.
.
 
CREATE TABLE  ReplicatorInfo  (
   id  INT(11) NOT NULL AUTO_INCREMENT,
   lastMessageReceivedTime   TIMESTAMP DEFAULT 0,
   lastModified  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ( id )
)ENGINE=INNODB;
.
.
blah blha etc etc
.
.

firstword="CREATE TABLE  ReplicatorInfo  ("
endpoint="engine=Innodb"
echo "`sed -n "/$firstword/,/$endpoint/ w tablextract.sql" < onlytables.sql`"

firstword='REPLICATORINFO'
endpoint='ENGINE=INNODB'
sed -n "h;y/abcdefghijklmnopqrstuvwxyz/ABCDEFGHIJKLMNOPQRSTUVWXYZ/;/$firstword/,/$endpoint/{x;P}" inputfile

$ firstword="CREATE TABLE  ReplicatorInfo  ("
$ endpoint="engine=Innodb"
$ sed -n "/$firstword/,/$endpoint/Ip" input
CREATE TABLE  ReplicatorInfo  (
   id  INT(11) NOT NULL AUTO_INCREMENT,
   lastMessageReceivedTime   TIMESTAMP DEFAULT 0,
   lastModified  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ( id )
)ENGINE=INNODB;