Aryeh Gregor wrote:
On Fri, May 22, 2009 at 6:09 PM, O. O.
<olson_ot(a)yahoo.com> wrote:
(That sed pattern is pretty horrifying and fragile, though. I'd
recommend something more like: sed -i 's/^) TYPE=InnoDB;$/)
TYPE=InnoDB DEFAULT CHARSET=binary;/' )
The shell is only handing the mysql command a file descriptor. mysql
will read the file itself directly, the shell won't touch any of the
input.
Thanks Aryeh for this clarification. I was really feeling that shell was
doing something – because I trusted the Wikipedia SQL dump. Thanks also
for your sed command – it is more general i.e. works for other files
where the line to be modified is not on line number 18.
O.O.