On Mon, 10 Mar 2008, Daniel Brown <parasane@gmail.com> wrote:
> mysql -D mysql -u xxx -p < mysql_tzinfo_to_sql /usr/share/zoneinfo/America/
>
> The -D flag selects the database `mysql`, which is where the time
> zone information belongs. The < redirect reads from the "file"
> (which, in this case, is actually a redirected STDOUT) into the
> database.

That is not legal shell syntax on UNIXy systems (or CMD.EXE, for that
matter). "<" is followed by the input file name, so the command above
would read a file named "mysql_tzinfo_to_sql" in the current
directory. It does not run the mysql_tzinfo_to_sql command. The way
to redirect command output into the input of another command is to use
"|" in the proper way. Please see the on-line man pages that I posted
in my other note a minute ago.

--
Tim McDaniel, tmcd@panix.com