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

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


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

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
           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