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(a)turnstone.co.nz Website: www.turnstone.co.nz -----Original Message----- From: wlug-bounces(a)list.waikato.ac.nz [mailto:wlug-bounces(a)list.waikato.ac.nz] 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(a)list.waikato.ac.nz 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.