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
--
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]