Re: No database selected error when running mysql_tzinfo_to_sql

[Tim McDaniel <tmcd@xxxxxxxxx>]

On Mon, 10 Mar 2008, Daniel Brown <parasane@xxxxxxxxx> 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@xxxxxxxxx

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx