MySQL loading a schema file with the '.my.cnf' file.

Madison Kelly linux-5ZoueyuiTZhBDgjK7y7TUQ at public.gmane.org
Wed Dec 14 19:15:28 UTC 2005


Madison Kelly wrote:
> Hi all,
> 
>   I'm trying to have my installer load a schema file into MySQL. I don't 
> want to pass the password over the command line so, on Fraser Campbell's 
> suggestion, I started using the '~/my.cnf' file. This file worked for 
> things like calling 'mysql_dump' and 'mysqladmin' but I can't seem to 
> get it to work for this command:
> 
> # mysql tle-bu -u root -p < /path/to/mysql.schema
> 
>   The schema itself is fine, I can load it fine manually. Here is what 
> is in my '/root/.my.cnf' file:
> 
> # cat ~/.my.cnf
> [mysql]
> password = blah
> [mysqladmin]
> password = blah
> [mysqldump]
> password = blah
> 
>   I've searched the MySQL docs (v4.1, btw) and can't seem to figure out 
> why this command is failing when other commands work without the 
> password. Is it perhaps the '<' command?
> 
> Thanks as always!!
> 
> Madison

GAH!!!

   I'd been fighting this for two darn hours... Not 30 seconds after I 
sent that email I realized what I was doing wrong (using the '-p' switch).

   I'm sorry for the line noise. ^_^;

Madison

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
           Madison Kelly (Digimer)
    TLE-BU; The Linux Experience, Back Up
Main Project Page:  http://tle-bu.org
Community Forum:    http://forum.tle-bu.org
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml





More information about the Legacy mailing list