Running a script with Crontab
| From: | ani at lamundial dot net | Date: | Sun, 30 Sep 2001 17:25:59 +0000 |
| Subject: | Running a script with Crontab | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-69371@lists.php.net to get a copy of this message | ||
This is what I do, maybe is gonna help you
bash file structure:
#!/bin/bash
##
## mysql maintenance
##
/usr/bin/mysql -u username --password=yourpassword <<EOF
use yourdatabase;
YOUR SQL query HERE;
exit
EOF
then
chmod +x yourbashfile
so "cronjob" this file with the desired frecuency
Ani Lopez
www.laMundial.net
download our free music