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]

Reply via email to