At 01:25 PM 9/30/2001, [EMAIL PROTECTED] wrote:
>This is what I do, maybe is gonna help you
>
>bash file structure:
>
> #!/bin/bash
> ##
> ## mysql maintenance
> ##
> /usr/bin/mysql -u username --password=yourpassword < use yourdatabase;
> YOUR SQL query HERE;
> exit
> EOF
>
>then
> chmod +x yourbashfile
>
>so "cronjob" this file with the desired frecuency
BAD BAD BAD idea.
if this is a public server (linux that's not running the openwall patch,
for example) then anyone can see your password with a `ps auxwww` while
it's running. Scripts I run from cron are usually recalculation scripts in
the middle of the night that take 10-15 mins to run, and as such would give
anyone more than enough time to grab it while the script is running, not
that it's not possible to grab it even with a shorter execution time as well.
-j
Jeffrey Paul [EMAIL PROTECTED] (877) 748 3467
ICQ: 14295546 AIM: kw34hd1 NXTL/DC: 130*21*16749
PGP: 0xF50BB9D7 A21AFD828C30EC77545DA0B3F501F50BB9D7
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]