On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
