This is what I do, maybe is gonna help you

bash file structure:

     ##  mysql maintenance
     /usr/bin/mysql -u username --password=yourpassword <<EOF
     use yourdatabase;
     YOUR SQL query HERE;

 chmod +x yourbashfile

so "cronjob" this file with the desired frecuency

Ani Lopez
download our free music

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to