Re: AW: [cobalt-users] Problems with cronjob

[Brent Sims <bs@xxxxxxxxxxx>]

On Sun, 21 Apr 2002, Axel Denk wrote:

} Does anyone have another tip, please? I really need the cronjob to be
} running.

Script it, using the full Unix path to each and every item, ie:

#!/bin/sh
/path/to/mysql -u test -pPassword < /path/to/include/file.sql

	After the script does what you want chmod 700 <script name>
so you have some lttle bit of security then run the script from
cron. I donno if this is more secure or not but you can avoid
putting the password in the script if you create a file, in the
user's home directory, named:

	.my.cnf

	Which contains the following:

	[client]
	password = PassWord

	chmod 600 on .my.cnf then that user will be able to login to
mysql via: mysql -u UserName (no password required).

	Peace be with you,

	Brent Sims
	WebOkay Internet Services, LLC
	http://www.WebOkay.net
	mailto: Brent@xxxxxxxxxxx
	(719) 595-1427 (Voice/Fax)