From: Tim McDaniel (tmcdpanix.com)
Date: Mon Mar 10 2008 - 10:36:03 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Mon, 10 Mar 2008, Daniel Brown <parasanegmail.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, tmcdpanix.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]