List:General Discussion« Previous MessageNext Message »
From:Daniel Brown Date:March 10 2008 4:05pm
Subject:Re: No database selected error when running mysql_tzinfo_to_sql
View as plain text  
On Mon, Mar 10, 2008 at 11:36 AM, Tim McDaniel <tmcd@stripped> wrote:
> On Mon, 10 Mar 2008, Daniel Brown <parasane@stripped> 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.

    You're right.  I can't find the pipe character on my Treo 700wx's
keyboard, so I meant to show an alternative method (directing it to a
file and directing the file into MySQL), but must've screwed up and
lost train of thought halfway through.  Odd.

    It should've been as follows:

        mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ >
/tmp/time_zone_info.sql
        mysql -D mysql -u xxx -p < /tmp/time_zone_info.sql

-- 
</Dan>

Daniel P. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>
Thread
No database selected error when running mysql_tzinfo_to_sqldpgirago10 Mar
  • Re: No database selected error when running mysql_tzinfo_to_sqlDaniel Brown10 Mar
    • Re: No database selected error when running mysql_tzinfo_to_sqlTim McDaniel10 Mar
      • Re: No database selected error when running mysql_tzinfo_to_sqlDaniel Brown10 Mar
  • Re: No database selected error when running mysql_tzinfo_to_sqlTim McDaniel10 Mar
Re: No database selected error when running mysql_tzinfo_to_sqldpgirago10 Mar
  • Re: No database selected error when running mysql_tzinfo_to_sqlTim McDaniel10 Mar
Re: No database selected error when running mysql_tzinfo_to_sqldpgirago10 Mar