Shell Scripting question

[Dave Tiger]

Thanks Rodger,

That now gives me what I wanted.

Now on with the rest of the hard work :-)

Thank you.

Dave C


--------------------------------------------
EPH Group Ltd.
Professional UK Based Web Hosting 
http://www.ephgroup.com  
In the UK? Call FREE: 0800 031 9190
Unlimited WebSpace, Unlimited Email Accounts, FREE Telephone Support,
FREE co.uk domain name, FAST FRIENDLY SERVICE, UNIX & Windows accounts
--------------------------------------------

-----Original Message-----
From: freebsd-users-admin at uk.freebsd.org
[mailto:freebsd-users-admin at uk.freebsd.org] On Behalf Of Roger McCalman
Sent: 15 April 2004 11:04
To: Dave Tiger
Cc: 'Roger McCalman'; freebsd-users at uk.freebsd.org
Subject: Re: Shell Scripting question


On Thu, Apr 15, 2004 at 10:55:08AM +0100, Dave Tiger wrote:
> Thanks Rodger for the info. Perl DBI is not an option at the moment 
> but I might go down that road if need be.
> 
> Sorry to be a bore but where in the string do I put the required -u -h 
> -p parts for the MySql connection ?

Anywhere between the mysql and the database name, I prefer after the mysql
i.e

mysql -u username -h dbhost -p password --skip-column-names --batch -e
'select ...' database | 

but I prefer not to put the password on the command line but to use mysql's
access control based on user and host. You can also use the my.cnf to set
defaults. man mysql also explains the other options.


Cheers, Roger (without a d)

------ FreeBSD UK Users' Group  -  Mailing List ------
http://listserver.uk.freebsd.org/mailman/listinfo/freebsd-users

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004