[PHP] Running a script with Crontab

Hello All, I wrote an script to do database maintenance and I forgot how to run a script on the command line without opening it with a web browser. My idea is to add a crontab daily entry to run this script. Can anyone enlight me on this thank you very much, C.F. Scheidecker Antunes.

[PHP] Running a script with Crontab

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

Re: [PHP] Running a script with Crontab

At 01:25 PM 9/30/2001, [EMAIL PROTECTED] wrote: 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;