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]