[SOLVED] Find and replace string

moyorakkhi · 07-26-2011, 12:33 AM

Hi Mates,

I need a help. I need to find this "TYPE=MyISAM;" and replace with "ENGINE=InnoDB;" in all .sql files in a directory. How can I do this with sed? Thanks for your help.

crts · 07-26-2011, 01:11 AM

Hi,

this should do it

Code:

sed -i.bak 's/TYPE=MyISAM;/ENGINE=InnoDB;/' *.sql

if all files are in the same directory. The -i.bak option will make a backup of the original file with *.bak suffix before making any changes.

moyorakkhi · 07-26-2011, 02:45 AM

Thanks a lot crts. That worked very well

Thanks for you time.