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