Aryeh Gregor wrote:
On Fri, May 22, 2009 at 6:09 PM, O. O. olson_ot@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.