Hi,

I have a a mysql dump text file.

I need to replace the below line
-------------------------------------------------------------------
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
-------------------------------------------------------------------

with this text

-------------------
) TYPE=MyISAM;
-------------------

using a shell script.

How can I do this.
Please help.

Thank you in advance.

regards,
Vai

One way:

sed 's/ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;/TYPE=MyISAM;/' oldfile > newfile

Hi Jim,

Thx for your quick reply.

I tried this....


sed 's/ENGINE=MyISAM*/TYPE=MyISAM;/' a.sql > b.sql

But it did not work.

Any idea how I can have a line-replace using a partial string match.

Thx
Vai

I tried this too:
sed 's/^) ENGINE=MyISAM*/TYPE=MyISAM;/' a.sql > b.sql

Inserting a ^ to indicate -- live starting with...
Did not help.

Thx

u missed out a dot '.'

sed 's/ENGINE=MyISAM.*/TYPE=MyISAM;/' a.sql > b.sql

Yes Indeed!!
The missing dot worked.
Thx a lot.

regards,
Vai