[wlug] CLI help

Thanks

I just tried the following variations with the following results.

ARGON:/home # find /path/* -name "*.sql" -exec mysql -p password -h < {} \;
-bash: {}: No such file or directory

ARGON:/home/ # find /path/ -name "*.sql" -exec mysql -p password -h < {} \;
-bash: {}: No such file or directory

ARGON:/home/ # find /path/* -exec mysql -p password -h < {} \;
-bash: {}: No such file or directory


Cameron Rangeley
Technical Director



Phone:               +64 9 970 5550
Direct:                +64 9 970 5551
Mobile:              +64 21 343 757
Email:                 cameron.rangeley@t...
Website:             www.turnstone.co.nz








-----Original Message-----
From: wlug-bounces@l... [mailto:wlug-bounces@l...] On Behalf Of Peter Reutemann
Sent: Tuesday, 9 March 2010 4:08 p.m.
To: Waikato Linux Users Group
Subject: Re: [wlug] CLI help

> Any idea what is wrong with this command??
>
>
>
> find /home/path/* -name *.sql -exec mysql -p password -h < {} \;
>
>
>
> I am needing to import about 250 sql files.

Try this:

find /home/path/ -name "*.sql" -exec mysql -p password -h < {} \;

BTW you will have to enter the password 250 times!

Cheers, Peter
--
Peter Reutemann, Dept. of Computer Science, University of Waikato, NZ
http://www.cs.waikato.ac.nz/~fracpete/           Ph. +64 (7) 858-5174
_______________________________________________
wlug mailing list | wlug@l...
Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug

--
This message was scanned by the Turnstone managed spam filter and is believed to be clean.